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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.