Hope this code may be useful, proc sql; create table dsout as select A.var1,A.var2,A.var3,B.var2 as var22,B.var3 as var23, C.var2 as var32,C.var3 as var33 from dsName1 as A left join dsName2 as B on A.var1=B.var1 left join dsName3 as C on B.var1=C.var1; quit; If you keep same variables overwriting of variable occur.
... View more