importing mulitple files and adding filename

thomask23 — Thu, 28 Feb 2019 18:10:47 GMT

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;

Re: importing mulitple files and adding filename

Reeza — Thu, 28 Feb 2019 18:44:29 GMT

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.

topic Re: importing mulitple files and adding filename in SAS Programming

importing mulitple files and adding filename

Re: importing mulitple files and adding filename