So I am trying to combine a bunch of tables into one based on certain conditions. I am not sure how I would write a macro or do loop for it so I dont have to repeat the union step for each table. This is what I have so far, and would need to do for ~80 tables create table test as select monthend, loan_no, balance, portfolio, DELQIND180 from lp.lp_200512 where DELQIND180 ne "0" and portfolio="CORE" or portfolio="NAT" union select monthend, loan_no, balance, portfolio, DELQIND180 from lp.lp_200601 where DELQIND180 ne "0" and portfolio="CORE" or portfolio="NAT" union select monthend, loan_no, balance, portfolio, DELQIND180 from lp.lp_200602 where DELQIND180 ne "0" and portfolio="CORE" or portfolio="NAT"; quit;
... View more