topic Re: Listing All Sub Folders In a Directory in SAS Programming

Listing All Sub Folders In a Directory

GeorgeBonanza — Thu, 09 Apr 2020 16:43:01 GMT

Someone is running data for me and saving the output in a sub folder of a Yearly directory. For example, I have a folder called "2020" and the data that is being run for me gets output to subfolders called "Jan062020", "Jan132020", "Jan202020", etc. and within each of these folders are a couple of datasets that always has the same names.

What I'd like to do is create a list of these sub folders that I can then loop over and pull in the datasets into an aggregated file.

I've spent some time Googling but can't find anything that fits my inquiry so I am hoping to find assistance here.

Thanks in advance for your time.

Re: Listing All Sub Folders In a Directory

andreas_lds — Thu, 09 Apr 2020 16:58:14 GMT

Can you use x-commands in the sas-session?

If yes, you could use something like

filename dirs pipe 'dir "YOUR_PATH" /a:d /b';

data dirs;
  length dirName $ 200;
  infile dirs;
  input dirName;
run;

I don't have access to sas right now, so the code is untested.

Re: Listing All Sub Folders In a Directory

Reeza — Thu, 09 Apr 2020 17:03:36 GMT

Example 2: List All Files within a Directory Including Subdirectories

https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0js70lrkxo6uvn1fl4a5aafnlgt.htm&docsetVersion=9.4&locale=en

Sample 24820: Creating a Directory Listing Using SAS for Windows

https://support.sas.com/kb/24/820.html

@GeorgeBonanza wrote:

Someone is running data for me and saving the output in a sub folder of a Yearly directory. For example, I have a folder called "2020" and the data that is being run for me gets output to subfolders called "Jan062020", "Jan132020", "Jan202020", etc. and within each of these folders are a couple of datasets that always has the same names.

What I'd like to do is create a list of these sub folders that I can then loop over and pull in the datasets into an aggregated file.

I've spent some time Googling but can't find anything that fits my inquiry so I am hoping to find assistance here.

Thanks in advance for your time.