topic Re: Run a macro on many files in New SAS User

Run a macro on many files

NewUsrStat — Thu, 04 Jul 2024 10:08:59 GMT

I have a number of files on which to run a macro. They are approximately 300. I have to do something like this:

%Counts(Mod1_PS);
%Counts(Mod2_PS);

Is there a way to "call" the macro on all files Mod*_PS from 1 to 300?

Thank you in advance

PaigeMiller — Thu, 04 Jul 2024 10:18:35 GMT

%macro around(nfiles=);
    %do i=1 %to &nfiles;
        %counts(mod&i._ps)
    %end;
%mend around;

%around(nfiles=300)

Kurt_Bremser — Thu, 04 Jul 2024 12:16:13 GMT

data _null_;
do i = 1 to 300;
  call execute(cats('%nrstr(%counts(Mod',i,'_PS))'));
end;
run;