Set statement for concatenating multiple table

[PravinMishra]

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

[Reeza]

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;

[Kurt_Bremser]

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.

[Karthikeyan]

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