topic Re: %do loop error? in SAS Programming

%do loop error?

ybz12003 — Thu, 02 Jul 2020 15:15:10 GMT

Hello,

I have a program shown below. An error message was shown in the log window. Please help me to fix it. Thanks.

%Macro format_Repeater;

	data Repeater_Rochester_a;
		set Repeater_Rochester;

	%do k = 1 %to 5;
	 		CaseID_&k. = compress(CaseID_&k., "_-");
	%end;
   
		put CaseID_&k.;
	run;
	%end;

%mend;
%format_Repeater;

The error message is list below.

Re: %do loop error?

Reeza — Thu, 02 Jul 2020 15:17:14 GMT

You forgot the error message, but it looks like you're mixing macro and array logic. Is there a specific reason to not stick with arrays?

Re: %do loop error?

ybz12003 — Thu, 02 Jul 2020 15:18:23 GMT

I am not sure what is going on, somehow I couldn't copy the error text here.

Re: %do loop error?

ybz12003 — Thu, 02 Jul 2020 15:19:53 GMT

Error: There is no matching %DO statement for the %end. The statement will be ignored.

Re: %do loop error?

ybz12003 — Thu, 02 Jul 2020 15:21:12 GMT

Never mind. I found out the issue. thank.

Re: %do loop error?

Reeza — Thu, 02 Jul 2020 15:22:49 GMT

Duplicate %end? 🙂

Re: %do loop error?

Tom — Thu, 02 Jul 2020 16:30:30 GMT

You have two %END statements and only one %DO statement. And neither is in the right place.

If you keep the first one then you will reference the macro variable K after the end of he %DO loop. In that case its value will be 6.

If you keep the second one then you have included the RUN statement into the %DO loop and the statements generated by K=2 to 5 will be outside of the data step.