topic Get *.txt filename as a variable in data in SAS Programming

Get *.txt filename as a variable in data

Theis — Thu, 10 Oct 2019 15:24:39 GMT

I have multiple textfiles seperated by length that I want to import. I want to know which textfile that is the source as a variable in the imported data. I import data with the following statement (it's simplified, there's 20+ variables in the original).

DATA WORK.DATA;

LENGTH

Debitor $ 10

Udligning 8

;

FORMAT

Debitor $CHAR10.

Udligning DATE9.

;

INFORMAT

Debitor $CHAR10.

Udligning DATE9.

;

INFILE '/home/…/*.TXT'

LRECL=32767

FIRSTOBS=3

ENCODING="LATIN9"

DLM='7c'x

MISSOVER

DSD ;

INPUT

Debitor : $CHAR10.

Udligning : ?? ANYDTDTE9.

;

RUN;

If I have two sources in my infil directory - source1.txt and source2.txt I want my data too look like this:

Debitor Udligning Source

ABCD 10JAN2019 Source1

EFGH 15JAN2019 Source1

IJKL 10FEB2019 Source2

Where the first two rows are from source1.txt and the second from source2.txt. Can anyone help me how to retrieve the txt filename and add it as a variable.

Thanks.

Re: Get *.txt filename as a variable in data

ballardw — Thu, 10 Oct 2019 15:40:49 GMT

Show the code you are using to read the data.

Likely you want the infile option Filename and an assignment to keep it in the data:

data read;
   infile fileref filename=infilename;
   length readfile $50.;
   readfile = infilename;
run;

make sure the length of the readfile variable will hold the path plus the name of the data file.

The variable Infilename would be a temporary variable not written to the data set.

If you are reading series of files in a single data step the Filename variable value will change to reflect the current source.

Re: Get *.txt filename as a variable in data

Theis — Mon, 14 Oct 2019 07:16:11 GMT

Thanks 🙂