topic Re: Create a 'DO' loop to run macro Based on the Folder names present a Folder in SAS Programming

Create a 'DO' loop to run macro Based on the Folder names present a Folder

SASuserlot — Wed, 02 Nov 2022 15:01:15 GMT

I am trying to compare the data present in the folder ( which check for latest data). I am running the macro to do this but I believe, I am not doing the efficient way. I have the folder structure like mentioned in the image ( Tried approximately to match my expectation). So I am expecting to check what States ( Folder names) present in the 'Expens-2022' and create a macro variables and compare that with the same state folders present in the 'Doc ' Folder instead checking the Expens-2022' folder and entering each state name while calling the macro. I do have the macro '%expense which do the job. But how to achieve this instead. I am trying to control the State macro variable ( if it makes any sense.) Thanks for your input.. Thank you for your input.

%expnse(state= , prv= );
--------
----------
-----------
%mend;

%expense(state= NJ,  prv= DOC);
%expense(state= MA,  prv= DOC);
%expense(state= NY,  prv= DOC);

Re: Create a 'DO' loop to run macro Based on the Folder names present a Folder

Tom — Wed, 02 Nov 2022 15:38:49 GMT

Do you have list of the states? If not then perhaps you can use the FIPSTATE() function to generate the list.

data _null_;
  do fip=1 to 56 ;
    state = fipstate(fip);
    if state ne '--' then do;
      call execute(cats('%nrstr(%expense)(state=',state,',prv=DOC)'));
    end ;
  end;
run;

Re: Create a 'DO' loop to run macro Based on the Folder names present a Folder

Daryl — Wed, 02 Nov 2022 16:14:23 GMT

I once wrote a SAS program that would shell out to the operating system, run an operating system directory listing to create a list of subdirectories in a folder (for example, in Windows:)
prompt:> cd C:\path\to\directory
prompt:> DIR *.
I may have redirected the output to a text file or somehow dumped the output (subdirectory names) into a SAS table, and then I just wrote a macro to iterate through the table of available directories. Looking for that code now but it might be gone.

Re: Create a 'DO' loop to run macro Based on the Folder names present a Folder

SASuserlot — Wed, 02 Nov 2022 19:40:47 GMT

Thank you Tom. It kind worked. I used the concept from your code. However got a question FIPstate creates the list of states. What's situation if the folder names are different?

Re: Create a 'DO' loop to run macro Based on the Folder names present a Folder

Tom — Wed, 02 Nov 2022 21:14:38 GMT

There are lots of ways to ask the operating system what files and directories exist.

Here is one that will span a whole sub-tree of the directory and collect all of the folders.

https://github.com/sasutils/macros/blob/master/dirtree.sas