data zerobal restdata; set have; if balance=0 then output zerobal;else output restdata; run; data zerobal (drop = balance rename=( newdt=snapt_dt)); set zerobal; format newdt mmddyy10.; newdt=mdy(month(snapt_dt),day(snapt_dt),year(snapt_dt)-1); run; proc sql; create table zerobal as select a.*,b.v1 as balance from zerobal a left join have b on a.newdt=b.snapt_dt and a.region=b.region; quit; data final; set restdata zerobal(drop=newdt); run;
... View more
