Hello everyone:
I am wondering is it possible to write a macro to read file
in different folders.
Like for example, I have 100 folders and within each folder,
it has another folder, within the sub folder It may contain a txt file that I
want to read with SAS. New folder can be created to include new file.
Folder1 folder2 file
A1 aa1 file1
A2 aa2 (nofile)
… .. …
A100 aa100 file100
Folder2 is within folder1 and file is stored in folder2.
Thanks
Chen Xu
1. do all files have the exact same structure
2. Is this in Windows or Unix
3. Can you run system commands through SAS on your computer, i.e. X commands or pipe?
You can create a list of the files using OS commands and then use the list of files/paths to import all the files assuming that all files have the exact same structure.
The specific OS command depends on your OS and if you can run system commands.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.