topic Re: Insert filename into table using datastep in SAS Programming

Insert filename into table using datastep

LAtwood — Fri, 21 Nov 2014 15:57:27 GMT

I am using the datastep to read in a text file. Each text file has a distinct filename. I'm unsure how to bring the distinct filename for each record into the table?

Here is my code:

libname YOKOGAWA "D:\***\*****\****\YOKOGAWA";

FILENAME NORM 1 \\**\***\SAS DATA NORMALIZER 1\NORMALIZER 1*.txt ;

data YOKOGAWA.NORM_1_YOKOGAWA

%let _EFIERR_ = 0; /*set the ERROR detection macro variable/*

infile NORM1 delimiter = ',' MISSOVER DSD lcrecl=32767

firstobs=20 EOV=SKIP;

informat yok_dttm ANYDTDTM23.;

informat fpm best32.;

input @; /*if skip then skip=0; else do; */

if skip then do;

skip=0;

input #19;

end;

else do;

input

yok_dttm

fpm

;

output;

end;

if _ERROR_ then call symputx('_EFIERR_',1);

RUN;

Re: Insert filename into table using datastep

ballardw — Fri, 21 Nov 2014 16:08:58 GMT

On the infile statement add:

FileName= TempFileName

This add a temporary variable that can be referenced but is not kept in the data set.

and in the body of the code

File = TempFileName;

this keeps the name of the file.

Re: Insert filename into table using datastep

LAtwood — Fri, 21 Nov 2014 16:47:57 GMT

One more question,

The filename includes the whole directory which is over 70 characters long. The results only display the first 8 characters. I tried using the informat to bring in all characters, but it does not work. Ideally, I would like to use something like the substr function and only display the last few characters of the filename.

Re: Insert filename into table using datastep

ballardw — Fri, 21 Nov 2014 17:00:29 GMT

Forgot to mention that you need to specify the length of the file variable before use

length file $ 70;

Re: Insert filename into table using datastep

LAtwood — Fri, 21 Nov 2014 17:24:08 GMT

Ok, I lied that wasn't my last question

I have added

infile filename = tempfilename;

length file $70.;

file=tempfilename;

In the log it lists the whole directory as the filename now. However, in the sas dataset file is only showing 8 characters. I tried adding "file" to the informat and format statements with 70 characters, but no success. What am I missing?

Re: Insert filename into table using datastep

LAtwood — Fri, 21 Nov 2014 17:30:37 GMT

Sorry found what I was missing.

I was missing the length for tempfilename.

Thanks you so much for your help.

Lori