DATA Step, Macro, Functions and more

Filename as a variable name

Accepted Solution Solved
Reply
Occasional Contributor SN
Occasional Contributor
Posts: 7
Accepted Solution

Filename as a variable name

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


Accepted Solutions
Solution
‎02-22-2013 11:25 AM
Respected Advisor
Posts: 3,156

Re: Filename as a variable name

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

SAS(R) 9.3 Statements: Reference

Haikuo

View solution in original post


All Replies
Solution
‎02-22-2013 11:25 AM
Respected Advisor
Posts: 3,156

Re: Filename as a variable name

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

SAS(R) 9.3 Statements: Reference

Haikuo

Occasional Contributor SN
Occasional Contributor
Posts: 7

Re: Filename as a variable name

Thanks this worked.

Super User
Posts: 11,343

Re: Filename as a variable name

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 202 views
  • 0 likes
  • 3 in conversation