macro, go back to loop

Ivy — Sun, 29 Apr 2018 21:01:21 GMT

Hello,

I am trying to run a loop in a Macro program.

I would like to go back to the loop if there is no observation in test2 . Is there any way for that ? Thank you very much.

%macro test ;

data test1;

set test;

where ;

run;

%do i= 1 %to 41;

data test2;

set test1;

where .....;

run;

..........

%end;

%mend;

Re: macro, go back to loop

ChrisNZ — Sun, 29 Apr 2018 22:05:57 GMT

Here is one way. Does it suit you?

%do i= 1 %to 41;

 proc sql;
   create table test2 as
   select *
   from test1
   where .....;
 run; 
 %if  &sqlobs=0 %then %goto next_iteration;
  
 ..........
 
 %next_iteration: 
%end;

topic macro, go back to loop in SAS Programming

macro, go back to loop

Re: macro, go back to loop