How to write a sas code to read file in different folders?

[gyambqt]

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

[Reeza]

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.