Hi,
I have below table and I want to create a single table out of that.
table_1,table_2,table_3,table_4,table_4,table_5.
I know I can use set statement in below way to concatenate it.
data table;
set table_1 table_2 table_3 table_4 table_4 table_5.;
run;
but don't want to do like this. I want to combine it using loop so that I don't have to write every table name.
Thanks
Don't be loopy.
data table;
set table_1 - table_5;
run;
Or to combine all tables that start with table_ use colon modifier.
data table;
set table_;;
run;
Where do you get the table names from? Depending on the way you do this, you could write a piece of code that creates the list of tables dynamically.
If you still want to try loop..
%macro table_create;
data
table
;
set
%do i = 1 %to 5
table_&i.
%end;
;
run;
%mend table_create;
%table_create;
Thanks
Karthik
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.