sas macro for appending 24 tables

Question

Hi I need help to append 24 sas tables. I would like to write a macro that appends 24 tables. How do I create a do loop with the least amount of typing. Thanks

proc sql;
create table master as
select * from table1
 union all
select * from table2
union all 
select * from table3;
quit;

I've linked you to a duplicate that does something similar to this. There are many other questions that ask a similar thing - search `append` in particular, as `proc append` is more efficient. — Joe, Jul 27 '15 at 16:01

score 2 · Answer 1 · answered Jul 27 '15 at 15:49

2

I think you did not need a macro. Just type

data master;
set table1-table24;
run;

answered Jul 27 '15 at 15:49

burduk

142
2
9

sas macro for appending 24 tables

1 Answers1