12-04-2014 06:44 PM
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.
12-04-2014 08:57 PM
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.