Filename as a variable name

[SN]

I have around 420 files. The id for the subject is the filename.

I would like to merge these 420 files as one file and tag the data for each subject with their id. Please could some one suggest, how could I create the filename as a variable (called id) inside the dataset for all the lines inside the dataset.

Once this is done, I could data merge the 420 files.

regards

SN

[Haikuo · Accepted solution]

If your "merge" means "stacking", then check out option: indsname= in "set statement"

SAS(R) 9.3 Statements: Reference

Haikuo

[SN]

Thanks this worked.

[ballardw]

If they are all structured the same they could be read at the same time avoiding the merge with the filename option assigning the value of the file name as a variable

filename myfiles "C:\path\*.csv"; /* or similar depending on your names and extensions*/

data want;

     infile myfiles filename= FileRead ; /* and other options needed to read your data*/

     input ...

run;