Hi , I am using the below query to join multiple tables using proc sql. Is it possible to perform the same in a data step ?
Could you please help me translate this in data step?
proc sql;
create table work.cte as
select distinct el.flag,
el.balance,
el.daysdelinq,
c.country,
c.postcode,
a.balance,
a.cl,
a.daysdelinq as daysdelinq_2,
a.schufaindicator,
a.finaccno as acct,
c.customerno,
el.row_no
from work.pes_row el,
pxm.accounts a,
pxm.accxref aref,
pxm.contacts c
where el.finaccno = a.finaccno
and a.acc = aref.acc
and aref.customerno = c.customerno
and a.finaccno in (select finaccno from work.acc_list_cards);
quit;
Thank you