Hello all, I need to find a way to use loop to union my datasets. For example, I have three tables with different column names. I want to union them all by using "outer nuion corr". The code like this: proc sql; create table new as select * from a1 outer union corr select * from b1 outer union corr select * from c1 ; quit; I want to use the loop function to do these unions. %macro union_a; proc sql; create table new as select * from a1 %do i = 2 %to 3; outer union corr select * from a&i ; quit; %end; %mend; %union_a; it gives me an error:   NOTE: Line generated by the invoked macro "UNION_A". 5 outer union corr select * from a&i ; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. How should I do this? Thank you! JH     ... View more

Hi all, I run SAS script every day. I get a small table like this: Obs County total_cases new_case 1 A 21 0 2 B 2 2 3 C 1 0 I want it to export to excel. On the second day, I run SAS, and I get another output: Obs County total_cases new_case 1 A 22 1 2 B 2 0 3 C 6 5 Can I export the results to the excel I create on the first day? The excel like this, Obs County total_cases new_case 1 A 21 0 2 B 2 2 3 C 1 0 1 A 22 1 2 B 2 0 3 C 6 5 Thank you all! JH ... View more