i think you can do left join in data step using Merge.Lets say I have two datasets Table1 and Table2 which have has common variable ID.We first need to sort the two datasets by ID.After Sorting the twosets we can code as : Proc Sql; Create table NEW as Select T1.*,T2.* from Table1 as T1 left join Table2 as T2 on T1.id=T2.id; Quit; This will give matching rows with the non-matching rows from left table in the new dataset NEW. Similarly in data step: Data NEW; Merge Table1(in=T1) Table2(in=T2); If T1; by ID; run; I suppose this works.Apologies if it does not help out.
... View more