adding a column for multiple tables

[ilikesas]

Hi,

suppose that I have 3 tables: A,B,C.

What I would like to do is for each table to add a new column called "table" and the value in each row of this new column for each table is the name of the table itself.

So table A will have a new column "table" with values a, a, a, a, ....

table B will have a new column named "table" with values b,b,b,...

And so on.

Thank you ! 

[Reeza]

Why would you want to do this?

[ilikesas]

Hi Reeza,

I have many tables of stocks. Each table is named after the stock and has two columns: "date" and "daily price".

In order to perform my analysis I need to merge all the tables together into one table, but since there is no indicator which date and price is for which stock, the analysis won't be possible.

Thank you!

[Reeza · Accepted solution]

I did put the answer above, under the spoiler tag on how you could do it via a macro. The solution below is what you really want though, which is what I suspected.

data want;
set stock1 stock2 stock3 stock4 indsname=source;
table=scan(source, 2);
run;

[ilikesas]

Thank you Reeza,

I got the answer that I needed!!!

Indsname happens to be a very useful function, I didn't even know it existed.

Thank you again!!!

[lissacoffey]

The solution above is what i really wanted

[Reeza]

Take advantage of the INDSNAME option to automatically grab the table name. 

I'm really curious for the use case of adding this variable, besides when you are setting multiple tables together and even then you can use the INDSNAME option directly. 

%macro add_name(dsn);

data &dsn;
set &dsn indsname=source;
Table = scan(source, 2);
run;

%mend;

%add_name(tableA);
%add_name(TableB)