importing mulitple files and adding filename

[thomask23]

I am attempting to import multiple text files.  I would like to add the file name as a column in the output file.  Is there an easy way to add this additional detail. My current code is written below

filename fref pipe "ls /unixlocation/files_&Mth.*.txt";

data work.file_curr;

infile fref;

input ;

file = scan(_infile_,-1,'/');

run;

proc import datafile="/unixlocation/files_&Mth.*.txt"

out=output(rename=(VAR1=newname1 VAR2=newname2 VAR6=newname3 VAR9=newname4))

dbms=csv

replace;

delimiter=',';

GETNAMES=NO;

datarow=2;

guessingrows=32000;

run;

[Reeza · Accepted solution]

You can't with PROC IMPORT, but you can if you use a data step. You can copy the code from the log and add the FILENAME/FILEVAR options to the INFILE statement.