@Sica wrote: Thank you a lot!! Is there an easy way to create a column and add the original file name from all values?
The Set statement option INDSNAME name will do that. The default behavior is to create a temporary variable, so you need to assign that value to a desired variable.
Example:
data junk;
set sashelp.class indsname=ds;
source=ds;
run;
DS is a temporary variable that holds the library and dataset name and will not be written to the output data set (that's what temporary means). Source is assigned the value of the variable DS and will be kept in the data. You only use the option one time and it really doesn't matter where it goes on the set statement.
... View more