topic Re: Macro keyword DO appears as text. in SAS Programming

Macro keyword DO appears as text.

imdickson — Thu, 19 Jul 2018 08:26:47 GMT

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.

Re: Macro keyword DO appears as text.

LinusH — Thu, 19 Jul 2018 08:38:32 GMT

You are missing a right parenthesis.

Re: Macro keyword DO appears as text.

imdickson — Thu, 19 Jul 2018 08:45:49 GMT

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.....

Re: Macro keyword DO appears as text.

LinusH — Thu, 19 Jul 2018 08:58:53 GMT

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

Re: Macro keyword DO appears as text.

s_manoj — Thu, 19 Jul 2018 11:15:34 GMT

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

Re: Macro keyword DO appears as text.

Ksharp — Thu, 19 Jul 2018 13:19:40 GMT

%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;