Hi ,
I have a folder that has multiple text files as below.
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.
try the link below.
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?
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.
If I were you, I will use infile + filevar= . it is very easy and flexility .
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.