How to Print a CSV Filename into a SAS Dataset

Reply
New Contributor
Posts: 2

How to Print a CSV Filename into a SAS Dataset

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!

Contributor
Posts: 32

Re: How to Print a CSV Filename into a SAS Dataset

Posted in reply to Wheelawake

Add this to your infile statement ....

FILENAME=whatever

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.

Tip:Use a LENGTH statement to make the variable length long enough to contain the value of the filename.

See:FILEVAR=

Example:Reading from Multiple Input Files



then module=whatever



Ask a Question
Discussion stats
  • 1 reply
  • 183 views
  • 1 like
  • 2 in conversation