Listing All Sub Folders In a Directory

[GeorgeBonanza]

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.

[andreas_lds · Accepted solution]

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.

[Reeza]

Example 2: List All Files within a Directory Including Subdirectories

https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0js70lrkxo6uvn1fl4a5aafnlgt.htm&docse...

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.

---