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

gyambqt — Thu, 04 Dec 2014 23:44:59 GMT

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

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

Reeza — Fri, 05 Dec 2014 01:57:18 GMT

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.

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

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

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