Looking to do something like this more efficiently: proc sql; create table newtable as select names, a.category1-b.category1 as category1, a.category2-b.category2 as category2, a.category3-b.category3 as category3, ... a.category100-b.category100 as category100 from a.tablea as a left join b.tableb as b on a.names=b.names; quit; I'm trying to create just one table and decrease the amount of lines I take up in my code. Figured that macro do loops may help, but not sure how. Please help! Thank you!!
... View more