topic Re: Conditionally leave %do loop in SAS Programming

Conditionally leave %do loop

chetan3125 — Fri, 15 Apr 2022 18:27:55 GMT

I have the code as below.

I want to stop the %do loop at first iteration because dataset e will have 0 obs. So it will not execute more statements inside the loop 1. (because it's a huge code and take very long)

Then loop 2 should begin normally and execute till end because dataset e will have observations.

Any ways to achieve this ?

I did research and Leave statement can do this in normal do loop but it won't work for macro loop.

Thanks.

%macro checkit;
%DO i= 1 %to 2;
	data  e ;
		x=2 ;
		if x=&i; 
	run;

/*    huge code and multiple loops here.....*/
%END;
%mend checkit;
 
%checkit;

Re: Conditionally leave %do loop

sbxkoenk — Fri, 15 Apr 2022 18:37:40 GMT

Hello,

See here :

SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation | SAS 9.4 / Viya 3.5
Macro Language Reference
%GOTO Macro Statement
Example: Providing Exits in a Large Macro
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0jfeh75p72icen1ddd9una5zbmm.htm

To check the n° of observations in your dataset, use this code :

data _NULL_;
 if 0 then set sashelp.shoes nobs=count;
 call symput('numobs',trim(left(put(count,11.))));
 STOP;
run;
%PUT &=numobs;

Good luck,

Koen

Re: Conditionally leave %do loop

Astounding — Fri, 15 Apr 2022 18:41:56 GMT

You should be able to use %GOTO. For example:

%macro checkit;
%DO i= 1 %to 2;
	data  e ;
		x=2 ;
		if x=&i; 
	run;
%if &i=1 %then %goto finish;
/*    huge code and multiple loops here.....*/
%finish:  %END;
%mend checkit;
 
%checkit;

Re: Conditionally leave %do loop

Kurt_Bremser — Sat, 16 Apr 2022 07:24:44 GMT

Wrap the code you want to execute conditionally in a %IF <condition> %THEN %DO; %END; block.