topic Re: Call Macro serveral times with incrementing the parameter in SAS Programming

Call Macro serveral times with incrementing the parameter

CM64 — Tue, 07 Dec 2021 22:53:16 GMT

I'd like to call a macro 200 times and increment the parameter with each call, but I don't want to repeat each call 200 times. Is there a %do %loop that can provide what I need?

%macro Weeks(week=);
proc sort data=in.test1 out=test1_W&week. (keep=subject); by subject; where folder="WEEK&week."; run;
run;
%mend;
%Weeks(Week=6); *increment by 6 for each macro call up to 200;
%Weeks(Week=12);
%Weeks(Week=18);
.
.
.
%Weeks(Week=200);

Re: Call Macro serveral times with incrementing the parameter

Reeza — Tue, 07 Dec 2021 23:00:15 GMT

Your requirements are unclear, is it:

repeat each call 200 times
increment by 6 for each macro call up to 200

Assuming the first one, use a data step loop and CALL EXECUTE. Modification for the second one is pretty straightforward in a data step as well.

data demo_run_macro;

increment=6;
do i=1 to 200;
      str = catt('%weeks(week=', i*increment, ');');
      call execute(str);
end;

run;

@CM64 wrote:

I'd like to call a macro 200 times and increment the parameter with each call, but I don't want to repeat each call 200 times. Is there a %do %loop that can provide what I need?

%macro Weeks(week=);
proc sort data=in.test1 out=test1_W&week. (keep=subject); by subject; where folder="WEEK&week."; run;
run;
%mend;
%Weeks(Week=6); *increment by 6 for each macro call up to 200;
%Weeks(Week=12);
%Weeks(Week=18);
.
.
.
%Weeks(Week=200);

Re: Call Macro serveral times with incrementing the parameter

Tom — Wed, 08 Dec 2021 00:10:41 GMT

To increment by 6 use the BY keyword on a DO loop.

filename code temp;
data _null_;
  file code;
  do week=6 to 200 by 6 ;
    put '%weeks(' week= ')';
  end;
run;
%include code / source2;