Hey everyone,
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.
for example:
data work.test;
infile 'C:\xxx.csv' dlm=',';
Module='INSERT CODE FOR FILENAME REFERENCE HERE'
length Student $20;
Input Student Grade;
format grade percent6.;
run;
proc print data=work.test;
run;
Then under the variable "Module", you would see "test 1" "test 2" "test 3" etc.
Thanks for your help!
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.
See:FILEVAR=
Example:Reading from Multiple Input Files
then module=whatever
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.