Desktop productivity for business analysts and programmers

Set statement for concatenating multiple table

Reply
Contributor
Posts: 60

Set statement for concatenating multiple table

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

Super User
Posts: 19,167

Re: Set statement for concatenating multiple table

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;

Super User
Posts: 7,447

Re: Set statement for concatenating multiple table

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 37

Re: Set statement for concatenating multiple table

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

Ask a Question
Discussion stats
  • 3 replies
  • 319 views
  • 1 like
  • 4 in conversation