topic Re: Set statement for concatenating multiple table in SAS Enterprise Guide

Set statement for concatenating multiple table

PravinMishra — Mon, 02 Mar 2015 23:32:26 GMT

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 — Mon, 02 Mar 2015 23:48:58 GMT

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 — Tue, 03 Mar 2015 07:37:03 GMT

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 — Tue, 03 Mar 2015 10:34:55 GMT

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