Go to the end of a Macro loop when condition met

[hhchenfx]

Hi Everyone,

I want to end an iteration and move to a new iteration when sample size is less than 5.

Can you please help me with that?

Thank you and have a nice weekend.

HHCFX

%MACRO test;
	%do i=1 %to 100;

		%do J=1 %to 100;

		LOT OF ANALYSIS;

		PROC SQL; SELECT COUNT(*) INTO: SAMPLE_SIZE FROM HAVE;QUIT;

		%IF &SAMPLE_SIZE<5 %THEN END THE INNER-LOOP (J)

		LOT OF ANALYSIS;

		%end;

	%end;
%MEND;

KEY

%MACRO test;
	%do i=1 %to %sysfunc(countw(&rr_list));
		%do J=1 %to %sysfunc(countw(&sl_list));

		LOT OF ANALYSIS;

		PROC SQL; SELECT COUNT(*) INTO: SAMPLE_SIZE FROM HAVE;QUIT;

		%IF &SAMPLE_SIZE<5 %THEN %GOTO EXIT_EXIT_EXIT;

		LOT OF ANALYSIS;

		%EXIT_EXIT_EXIT;

		%end;

	%end;
%MEND;

[PeterClemmensen · Accepted solution]

you can use the %GOTO Macro Statement 

[hhchenfx]

Thank you.

So it will be like that, right?

%MACRO test;
	%do i=1 %to %sysfunc(countw(&rr_list));
		%do J=1 %to %sysfunc(countw(&sl_list));

		LOT OF ANALYSIS;

		PROC SQL; SELECT COUNT(*) INTO: SAMPLE_SIZE FROM HAVE;QUIT;

		%IF &SAMPLE_SIZE<5 %THEN %GOTO EXIT_EXIT_EXIT;

		LOT OF ANALYSIS;

		%EXIT_EXIT_EXIT:

		%end;

	%end;
%MEND;

[art297]

I think you want to replace the semi-colon after 

%EXIT_EXIT_EXIT;

with a colon (i.e., : )

Art, CEO, AnalystFinder.com

[PeterClemmensen]

Looks right.