Read file names from .txt to produce master dataset.

Babloo — Mon, 14 Sep 2015 13:46:18 GMT

My requirement is to read the .txt file which has filenames as follows. Now I need to read all these files to produce a master datset. All these files has a same layout.

SASApp_STPServer_2015-09-13_cmsaslva2_19142.log

SASApp_STPServer_2015-09-13_cmsaslva2_19143.log

SASApp_STPServer_2015-09-13_cmsaslva2_19144.log

I was trying to read all these filas as below code,but this code is not working as I excepted.Because only 1 record from each infile read instead of reading all the records.

I'm not sure for this strange behaviour.Please guide me.

DATA output_data_set;
/* read the file references in variable called file_names */
INFILE  '/temp/test/inputfile_txt' dsd truncover FILEVAR = file_names END = end_of_file LRECL=32000;
     DO WHILE (end_of_file = 0);
        input var : $ 3000.;
/*filename=file_names;*/
var1 = _infile_;
if var1 = :'201';
Date_TimeStamp= scan(var1,1," ");
Status = scan(var1,2," ");
Processid = scan(var1,3," ");
userid = scan(var1,4," ");
Details = scan(var1,-1,'-');
drop var var1;
        OUTPUT;
     END;
RUN;

Re: Read file names from .txt to produce master dataset.

RW9 — Mon, 14 Sep 2015 13:56:44 GMT

Hi,

This seems to very simliar to this question:

https://communities.sas.com/t5/Base-SAS-Programming/Read-the-file-names-and-create-a-dataset/m-p/225338

I have responded there (however am struggling to use the new forum, and can't see that response).

topic Re: Read file names from .txt to produce master dataset. in SAS Programming

Read file names from .txt to produce master dataset.

Re: Read file names from .txt to produce master dataset.