Good day,
I have the below SAS code, I want it to code it in Qlikview script,
How should I go about?
Thanks a lot in advance
/* Accounts for which billed amount >0 */
data prev_balanced;
set port_&prev_month.(keep=id_acc PREV_STATEMNT_ACCT_BAL ect_flag class);
where PREV_STATEMNT_ACCT_BAL>0;
run;
/* Dataset for transactor accounts */
proc sql;
create table transactor as
select * , 1 as transactor_flag
from active_accounts_final
where ect_flag ne 1 and id_acc in
(select id_acc from prev_balanced);
quit;
/* Dataset for revolver accounts */
proc sql;
create table revolver as
select *
from active_accounts_final
where ect_flag = 1 and id_acc in
(select id_acc from prev_balanced);
quit
