SAS: concatenate different datasets while keeping the individual data table names?

Question

I'm trying to concatenate multiple datasets in SAS, and I'm looking for a way to store information about individual dataset names in the final stacked dataset. For eg. initial data sets are "my_data_1", "abc" and "xyz", each with columns 'var_1' and 'var_2'. I want to end up with "final" dataset with columns 'var_1', 'var_2' and 'var_3'. where 'var_3' contains values "my_data_1", "abc" or "xyz" depending on from which dataset a particular row came. (I have a cludgy solution for doing this i.e. adding table name as an extra variable in all individual datasets. But I have around 100 tables to be stacked and I'm looking for an efficient way to do this.)

Answer 1

Here's a simple solution for your 3-dataset example that can be expanded, not necessarily painlessly, to many more datasets:

data final;

set

my_data_1(in=in1 )

abc (in=in2 )

xyz (in=in3 )

;

format var_3 $15.;

if in1 then var_3='my_file';

else if in2 then var_3='abc';

else if in3 then var_3='xyz';

run;