Macro keyword DO appears as text.

[imdickson]

Hello Everyone.

I need help to solve this macro. My macro is as below:

%macro checkabc();
	%if %sysfunc(scan(&SCREAM,-1,'_') eq 'ABC' %then %do;
		%let SCREEN = %sysfunc(tranwrd(&SCREAM,'_ABC',)
	%END;
%end;
%checkabc;

i am getting the following error:

ERROR: Macro keyword DO appears as text.
ERROR: A dummy macro will be compiled.
90        +		%let SCREAM = %sysfunc(tranwrd(&SCREAM,'_ABC',)
ERROR: Macro keyword LET appears as text.
91        +	%END;
92        +%end;
ERROR: Macro keyword END appears as text.

I suspect 1 or more code is not quoted properly/wrongly used. I need advice on how to improve this macro.

Hope to get advice soon. 🙂

Thanks a lot everyone.

[LinusH]

You are missing a right parenthesis.

[imdickson]

Thanks for the help. I missed out 2 right parenthesis.

I also added 2 single quote in tranwrd.

However, I am still getting error as below.

ERROR: Macro keyword END appears as text.
ERROR: A dummy macro will be compiled.

My current macro code:

%macro checkabc();
	%if %sysfunc(scan(&SCREAM,-1,'_')) eq 'ABC' %then %do;
		%let SCREAM = %sysfunc(tranwrd(&SCREAM,'_ABC',''))
	%END;
%end;
%checkabc;	

what else could be wrong here.....

[LinusH]

You are now missing a semi colon, and you have to use %mend, not %end.

[s_manoj]

s you already aware about parenthesis were missing,
; is missing for %let statement and after %end have to inlude %mend;

[Ksharp]

%macro checkabc;
	%if %sysfunc(scan(&SCREAM,-1,_)) eq ABC %then %do;
		%let SCREAM = %sysfunc(tranwrd(&SCREAM,_ABC,%str( )));
	%END;
%mend;


%let scream=XX_ABC ;
%put before: &scream;
%checkabc
%put after: &scream;