topic Nested %do %while-loops inside a macro in New SAS User

Nested %do %while-loops inside a macro

Scorpx — Tue, 29 Jan 2019 21:44:16 GMT

Hello community,

I am trying to make a %do %while nested loop here, can you please check if there is an error? because when I run the code it iterates for CHAN A and the 12 month but it closes and didn't do chan B....

Thank you

%let CHAN=A B C D E;
%let MONTH=JAN FEB MAR APR MAY JUN JUL AGO SEP OCT NOV DEC;

%macro TEST ();

%local i j month_1 chan_1;
%let j=1;
%let i=1;

%do %while (%scan(&chan, &j.) ne );
%let chan_1 = %scan(&chan, &j.);

%do %while (%scan(&month, &i.) ne );
%let month_1 = %scan(&month, &i.);

 /*SOME STEPS HERE*/

   %let i = %eval(&i. + 1);
  
%end;
%let j = %eval(&j. + 1);
%end;

%mend TEST;

Using SAS EG 7.13

Re: Nested %do %while-loops inside a macro

Tom — Tue, 29 Jan 2019 22:43:14 GMT

You forgot to reset I.

Move the %LET I=1 inside the outer loop.

Why are you incrementing the loop counter yourself? Why not just let SAS do that?

%do j=1 %to %sysfunc(countw(&chan));
  %let chan_1 = %scan(&chan, &j.);
  %do i=1 %to %sysfunc(countw(&month));

Re: Nested %do %while-loops inside a macro

Scorpx — Wed, 30 Jan 2019 12:53:25 GMT

Thank you Tom,

I did work with your suggestion!