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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.