SAS/SQL Script to Qlikview Script

[#1]

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

[#2]

Yes they come from that file too. they are in excel

[Gysbert_Wassenaar]

Great. Create a small extract from that excel file that we can use as sample data.