@novinosrin, I think you could improve the SQL query like so: proc sql; create table want as /*(drop=rn)*/ select a.studyID, a.Var1, /*ifn(min(rn)=a.rn,b.var2,0)*/ /*I'm getting confused as to what the initial intent was but I'll come back to this Var2 selecting later*/ from ( select studyid, var1, monotonic() as rn from have1 ) a /*var1_table*/, have2 b /*var2_table*/ where a.studyid=b.studyid group by a.studyid order by studyid, rn; quit;
... View more
