DATA Step, Macro, Functions and more

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

Reply
Regular Contributor
Posts: 152

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

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

Super User
Posts: 17,837

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

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 Smiley Happy and if you can run system commands.

Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation