Hi people, What's the best way to improve this SQL code below for having a good performance? Could be in Proc SQL or Data Step. Any help will be greatly acceptable; Each table has about 13.018.525 rows and 250 columns. proc sql; create table preparacao as select a.DOSSIE, a.TDPRCPRODCOM, a.TDPRCPOSA, a.TDPRNAGCRCVT, a.JAN_CREAT, a.LMA, a.TDPRMFORIG, a.TDPRBFINORIG, a.CADEIA, a.atraso_atual_old, a.TDPRCPAIEMENT, a.SALDO_TOTAL, a.TDPRCVERROU, a.TALPCPSA, a.TDPRNQUANT, a.TCLINIDENT, b.atraso_atual_old as AT_H1, (b.SALDO_PAG/b.SALDO_MES) as PCT_PAG_H1, b.SALDO_TOTAL as SALDO_H1, b.TODU_PFRA as TODU_PFRA_H1, c.atraso_atual_old as AT_H2, (c.SALDO_PAG/c.SALDO_MES) as PCT_PAG_H2, c.SALDO_TOTAL as SALDO_H2, c.TODU_PFRA as TODU_PFRA_H2, d.atraso_atual_old as AT_H3, (d.SALDO_PAG/d.SALDO_MES) as PCT_PAG_H3, d.SALDO_TOTAL as SALDO_H3, d.TODU_PFRA as TODU_PFRA_H3, sum(b.RECEITA,-c.RECEITA) as RECEITA_H1, sum(c.RECEITA,-d.RECEITA) as RECEITA_H2, sum(d.RECEITA,-e.RECEITA) as RECEITA_H3, i.mtrotmes, i.mail, i.sms, i.tlmkt, i.TCLILNOMPREN, i.TCLFNDDDP, i.TCLFNTELP, i.TCLINDDDEMP, i.TCLINTELEMP, i.TCLINDDDCEL, i.TCLINTELCEL, i.TVDCHAINE, i.tdprnsoc, i.talpcposdosa, i.tdcpcficp, i.d_cre, i.TDCPBMONTSSR12M, i.D_PCP from nbdos.base_portmanagement_201203 as a left join nbdos.base_portmanagement_201202 as b on a.DOSSIE=b.DOSSIE left join nbdos.base_portmanagement_201201 as c on a.DOSSIE=c.DOSSIE left join nbdos.base_portmanagement_201112 as d on a.DOSSIE=d.DOSSIE left join nbdos.base_portmanagement_201111 as e on a.DOSSIE=e.DOSSIE left join baseseg_201204 as i on a.DOSSIE=i.DOSSIE ; quit; Thanks.
... View more