Reading multiple external folder names and files

hanahch — Tue, 01 Aug 2023 05:14:02 GMT

Hello SAS expert,

I have the following SAS program that uses macro variables to retrieve the folder name for individual cases and processes the data within each case folder. Currently, the program processes one case at a time, and since there are 100 case folders, it becomes impractical to manually select each case. How can I modify the program so that it automatically retrieve the next case and repeat the process until all 100 cases have been handled. Your help is much appreciated. Thank you!

Sample of case folder names:

%LET id=1001B; /** individual case folder name */

%LET folder=C:\DDS;

LIBNAME ddsdata "&folder";

options dlcreatedir;
libname newdir "&folder/OUTPUT"; /creates folder where processed data will be stored */

* the following lines run DDS programs;
%INCLUDE "&folder\dssformat.sas";
%INCLUDE "&folder\dssINPUT.SAS";
%INCLUDE "&folder\ngaINPUT.SAS";
%INCLUDE "&folder\ddsmain.SAS";

Re: Reading multiple external folder names and files

Kurt_Bremser — Tue, 01 Aug 2023 05:46:19 GMT

You do not seem to use the macro variable id in the code.

Anyway: wrap everything into a macro definition with id as parameter. Create a dataset with all id's. Then call the macro from this:

data _null_;
set id_dataset;
call execute(cats('%nrstr(%your_macro(',id,'))'));
run;

topic Re: Reading multiple external folder names and files in New SAS User

Reading multiple external folder names and files

Re: Reading multiple external folder names and files