02-22-2013 10:53 AM
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.
02-22-2013 01:14 PM
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*/
infile myfiles filename= FileRead ; /* and other options needed to read your data*/
Need further help from the community? Please ask a new question.