topic Re: %DO statement is not valid in open code in SAS Programming

%DO statement is not valid in open code

Ying — Sun, 19 Dec 2010 15:37:55 GMT

Good morning,

Here is the macro variables I created but I got error message and I am not sure why? Could you please help? Thank you! Y

ERROR: The %DO statement is not valid in open code.

[/prep]
%let org_date = "16Dec2009"d;
%let calendar_mn = 3;

%macro get_all;
%do increm=1 %to &calendar_mn %do;
data cal_date;
decrem=&increm-1;

if decrem=0 then beg_date = &org_date;
else beg_date = intnx('month', &org_date, decrem );
end_date = intnx('month', &org_date, &increm );

call symput("beg_date", compress(put(beg_date, 11.)));
call symput("end_date", compress(put(end_date, 11.)));
run;

%end;
%mend get_all;

%get_all

[/prep]

Re: %DO statement is not valid in open code

art297 — Sun, 19 Dec 2010 15:48:18 GMT

Ying,

Not sure why you would get that particular error message, but you have an extra %do.

That is, you have:

%do increm=1 %to &calendar_mn %do;

but should only have had:

%do increm=1 %to &calendar_mn;

HTH,
Art

Re: %DO statement is not valid in open code

sbb — Sun, 19 Dec 2010 17:05:43 GMT

Suggest pasting your SAS-generated log as you see it into a post-repy here, rather than just your SAS code.

Scott Barry
SBBWorks, Inc.

Re: %DO statement is not valid in open code

Ying — Sun, 19 Dec 2010 18:20:02 GMT

Thank you so much, art297! The ERROR's gone!

Re: %DO statement is not valid in open code

ArtC — Sun, 19 Dec 2010 22:37:19 GMT

Not that it particularly matters, but....

[pre]%do increm=1 %to &calendar_mn %do;[/pre]

I suspect that the second, extra, %DO is masked during macro compilation by the first %DO statement, and then exposed during macro execution - thus the 'in open code error'. Although I am surprised that there was not an error during the macro compilation of the iterative %DO statement.