How to Print a CSV Filename into a SAS Dataset

Wheelawake — Tue, 20 Aug 2013 17:09:40 GMT

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!

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

AdrianGriffin — Tue, 20 Aug 2013 18:47:05 GMT

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

topic Re: How to Print a CSV Filename into a SAS Dataset in SAS Programming

How to Print a CSV Filename into a SAS Dataset

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