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

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

kmin87 — Mon, 10 May 2021 21:13:16 GMT

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?

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

ballardw — Mon, 10 May 2021 21:20:45 GMT

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.

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

kmin87 — Mon, 10 May 2021 21:28:46 GMT

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

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

ballardw — Mon, 10 May 2021 21:41:52 GMT

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.