After putting two data set together using set, how do i create a column knowing which data variables

[kmin87]

For example

//

DATA tablea;

color="blue"

name="mike"

run;

DATA tableb;

color="pink"

name="sara"

run;

DATA two_data;

set work.tablea

work.tableb;

run;

How do I create a column/variable showing which row belongs to tablea or tableb?

[ballardw · Accepted solution]

The SET statement INDSNAME option.

DATA two_data;
   set work.tablea
        work.tableb
        indsname=tempvar
   ;
   source=tempvar;
run;

 

INDSNAME assigns the name of the source data set to a temporary variable. If you want that in the output set you need to assign it to another variable as above.

[kmin87]

When I export it to excel, the source column is blank. how do i show it on excel?

[ballardw]

Show the LOG of the code you ran to combine the data set and "export to Excel".

Go to the log, copy the text, on the forum open a text window with the </> icon at the top of the message window and then paste the text.

Note that depending on how you "export" you may not have replaced an older version.