08-20-2013 01:09 PM
I am trying to create a variable that references the input file's filename (without extension). Is there a way to do this? I am going to combine multiple test files into one excel file so I can run pivot tables for grade reports. Using the filename would be an easy way to assign the module or test name.
infile 'C:\xxx.csv' dlm=',';
Module='INSERT CODE FOR FILENAME REFERENCE HERE'
length Student $20;
Input Student Grade;
format grade percent6.;
proc print data=work.test;
Then under the variable "Module", you would see "test 1" "test 2" "test 3" etc.
Thanks for your help!
08-20-2013 02:47 PM
Add this to your infile statement ....
specifies a variable that SAS sets to the physical name of the currently opened input file. Like automatic variables, the FILENAME= variable is not written to the data set.