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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.