topic Re: Macro Issues with %Mend in SAS Programming

Macro Issues with %Mend

devizeskayak — Mon, 29 Mar 2010 19:49:22 GMT

Hey Guys,
I'm consistently getting the following error: Macro keyword MEND appears as text. A semicolon or other delimiter may be missing.

I can get the macro to run by submitting the following string a few times:

*'; *"; *); */; %mend; run;

although once the macro has compiled, it produces a recursive reference error for the variable CLUST. IF someone would be willing to look at my code and let me know what they think is going wrong that would be great!

Cheers,
Ashton

%macro clusfinal (data = , clust=) ;
data clusdat1;
set &data;
if cluster ne &clust then mean1 = "."; run;
proc arima data = clusdat1;
identify var = mean1 (1);
run;
estimate p = 1 outest = autoclus'&clust' ;
RUN;
proc print data = autoclus;
run;
%mend;

%clusfinal (data = clusdata, clust =1);

Re: Macro Issues with %Mend

sbb — Mon, 29 Mar 2010 20:37:05 GMT

You need to share your SAS code execution (and compilation) as part of a complete SAS log, not just the code-piece you might think is related. Ensure that all code (including macros and macro variables) are revealed - such as using:

OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MLOGIC MPRINT;

In fact, this additional level of diagnostics may help you with desk-checking the code execution for culprit like open comment or missing semi-colon.

Scott Barry
SBBWorks, Inc.

Re: Macro Issues with %Mend

Doc_Duke — Tue, 30 Mar 2010 01:52:13 GMT

For this line,

estimate p = 1 outest = autoclus'&clust' ;

you need to use double-quotes (") to get it to resolve to

estimate p = 1 outest = autoclus1;

Re: Macro Issues with %Mend

devizeskayak — Tue, 30 Mar 2010 13:39:21 GMT

Thanks guys! got it resolved with the change from single quotes to doubles. Appreciate the help.

-A