topic Re: Macro to read multiple txt files in SAS Procedures

Macro to read multiple txt files

raveena — Wed, 03 Oct 2012 19:11:18 GMT

Hi ,

I have a folder that has multiple text files as below.

\\hfn5\SASPROD\H10521R1.TXT

\\hfn5\SASPROD\H10522R1.TXT

\\hfn5\SASPROD\H10523R1.TXT

\\hfn5\SASPROD\H10524R1.TXT

\\hfn5\SASPROD\H10525R1.TXT

\\hfn5\SASPROD\H10526R1.TXT

I need to read all text files data from the above folder by using macro code instead of infile statement because the files will get updated frequently and create a sas dataset for further analysis.

Please help me how to create a macro to read all txt files data in the sas dataset ?

Thanks for your help.

Re: Macro to read multiple txt files

Linlin — Wed, 03 Oct 2012 19:19:58 GMT

try the link below.

https://communities.sas.com/thread/34190

Re: Macro to read multiple txt files

art297 — Wed, 03 Oct 2012 20:05:09 GMT

From your explanation I don't see how a macro would be better than a route similar to what Linlin suggested. I do have a couple of questions, though. What will determine if a file should be imported? Do all of the files end up getting appended to one SAS file? Do the files that were already uploaded have to be replaced and/or updated?

Re: Macro to read multiple txt files

raveena — Wed, 03 Oct 2012 20:10:09 GMT

Yes Arthur, once the file was imported it has to be append into one SAS file.Once in a week the additional files will get uploaded to the production folder, inorder to avoid the programming changes everytime we tried to create a macro that reads a additional and existing file from the folder.

Re: Macro to read multiple txt files

Ksharp — Thu, 04 Oct 2012 03:06:40 GMT

If I were you, I will use infile + filevar= . it is very easy and flexility .

Re: Macro to read multiple txt files

ArtC — Thu, 04 Oct 2012 05:54:08 GMT

Am I missing something or is it as simple as adding a wildcard into the FILENAME statement:

filename intxt "c:\temp\xx*.txt";

data want;

infile intxt;

input var $;

run;