Try below and see if there is any improvement. Solution 1: DATA wuTemp.CustTRBcur (keep='Version Date'n 'HUB Cust Id'n 'Last Month Average Balance'n where=('Version Date'n=&CurDate and 'Last Month Average Balance'n>=0)) ; SET CNMAP.VIEW_MAPRH_M_CN_CUS_TRB ; run; Solution 2: proc sql; create table wuTemp.CustTRBcur as select 'Version Date'n , 'HUB Cust Id'n , 'Last Month Average Balance'n from CNMAP.VIEW_MAPRH_M_CN_CUS_TRB where 'Version Date'n=&CurDate and 'Last Month Average Balance'n>=0; quit;
... View more