full join table2 as b on a.g3 = b.g3 order by 1; proc sql; title 'Merged'; select g3, z, r from table1 as a full join table2 as b on a.g3 = b.g3 order by 1;