topic Re: Go to the end of a Macro loop when condition met in SAS Programming

Go to the end of a Macro loop when condition met

hhchenfx — Fri, 29 Mar 2019 21:12:40 GMT

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;

Re: Go to the end of a Macro loop when condition met

PeterClemmensen — Sat, 10 Feb 2018 15:26:20 GMT

you can use the %GOTO Macro Statement

Re: Go to the end of a Macro loop when condition met

hhchenfx — Sat, 10 Feb 2018 15:52:11 GMT

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;

Re: Go to the end of a Macro loop when condition met

art297 — Sat, 10 Feb 2018 17:13:31 GMT

I think you want to replace the semi-colon after

%EXIT_EXIT_EXIT;

with a colon (i.e., : )

Art, CEO, AnalystFinder.com

Re: Go to the end of a Macro loop when condition met

PeterClemmensen — Sat, 10 Feb 2018 15:49:52 GMT

Looks right.