Not sure about exact data structures of the mentioned tables, I tried in this way. proc sql; create table master_plus_updated as select a.date,a.a,a.b,a.c,b.a as up_a,b.b as up_b,b.c as up_c from master a inner join updated b on a.date=b.date; quit; data final(drop=i up_a up_b up_c); set master_plus_updated; array master{*} a b c; array updated{*} up_a up_b up_c; do i=1 to dim(master); if missing(updated{i}) then master{i}=updated{i}; if _n_<4 then master{i}=.; end; run; proc print data=final; run;
... View more