Thanks. I got it to work. Just in case anyone else refers to this in the future, here's what I used
proc sql; create table want as select *, coalesce (a.tos1,b.tos1) as tostos1, coalesce (a.tos2,b.tos2) as tostos2 from out.table2 A left join out.table1 B on a.mapcd = b.mapcd; quit;
... View more