topic Re: How to resolve Concatenation(||) and percent,& symbols in macros in SAS Programming

How to resolve Concatenation(||) and percent,& symbols in macros

Siva_Harish — Mon, 11 Jan 2021 10:56:24 GMT

%macro EM(cntry=);

%let cntr = %sysfunc(compress(&cntry.));

%put cntry resolves to &cntry ;

%if "&cntry."="OMAN" or "&cntry." = "CHINA" %then %let like_cntry=%nrbquote('&cntry.%');  
 %else %let like_cntry=%nrquote('%')||%bquote('&cntry.')||%nrquote('%') ;

%put like_cntry resolves to &like_cntry.;
%mend
%em(cntry=japan)

Hi,

I want to resolve &like_cntry as '%japan%' since iam using in where clause

when i was trying to resolve iam getting this output '%'||'japan'||'%'

Can anyone help me on this?

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Shmuel — Mon, 11 Jan 2021 11:20:57 GMT

To concatenate macro variables you cant use '||' (nor '!!').

In order to dislay the &cntry value you must use double quotes.

Check next code:

%macro EM(cntry=);
	%let cntr = %sysfunc(compress(&cntry.));
	%put cntry resolves to &cntry ;
	%if "&cntry."="OMAN" or "&cntry." = "CHINA" 
	   %then %let like_cntry=%nrbquote("&cntry.%");  
	   %else %let like_cntry=%nrbquote(%)&cntry.%nrbquote(%);
    %put like_cntry resolves to &like_cntry.;
%mend;
%em(cntry=OMAN);
%em(cntry=japan);

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Shmuel — Mon, 11 Jan 2021 11:28:04 GMT

t can be even more simple - both methods were tested:

%macro EM(cntry=);
	%let cntr = %sysfunc(compress(&cntry.));
	%put cntry resolves to &cntry ;
	%if "&cntry."="OMAN" or "&cntry." = "CHINA" 
	   %then %let like_cntry=&cntry.%;  
	   %else %let like_cntry=%nrbquote(%)&cntry.%; /*nrbquote(%);*/
    %put like_cntry resolves to &like_cntry.;
%mend;
%em(cntry=OMAN);
%em(cntry=japan);

Re: How to resolve Concatenation(||) and percent,& symbols in macros

gamotte — Mon, 11 Jan 2021 11:34:29 GMT

Hello,

What is the following instruction used for ?

%let cntr = %sysfunc(compress(&cntry.));

If you want to remove leading and trailing blanks, the following will be enough :

%let cntr=&cntry.;

By using compress, you also remove blanks in the country name so "COSTA RICA", for instance, will become "COSTARICA".

Try the following code and look at the log :

data _NULL_;
call symput("cntry","  COSTA RICA   ");
run;

%put ***&=cntry.***;

%let cntr = %sysfunc(compress(&cntry.));

%put ***&=cntr.***;

%let cntr2=&cntry.;

%put ***&=cntr2.***;

Note that it would not have been necessary if symputx had been used instead of symput.

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Ksharp — Mon, 11 Jan 2021 12:33:32 GMT

%macro EM(cntry=)/minoperator mindelimiter=',';
%put cntry resolves to &cntry ;

%if %upcase(&cntry.) in OMAN,CHINA %then %let like_cntry=%bquote('&cntry.%');  
 %else %let like_cntry=%sysfunc(compress(%bquote('% &cntry.%'),%str( ))) ;

%put like_cntry resolves to &like_cntry.;
%mend;
%em(cntry=japan)
%em(cntry=china)

How about this one ?

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Tom — Mon, 11 Jan 2021 14:51:21 GMT

To put the values of macro variables next to each other just evaluate them next to each.

&X.&Y.

If you just remove the spurious vertical bar characters from your source code then and they won't end up in the generated code.

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Siva_Harish — Fri, 22 Jan 2021 15:59:01 GMT

This also worked for me but i want '%japan%' (including quotes) . I resolved the issue .Thank you..!!

Re: How to resolve Concatenation(||) and percent,& symbols in macros

Ksharp — Sat, 23 Jan 2021 10:37:54 GMT

Did you run my code ?

1 %macro EM(cntry=)/minoperator mindelimiter=',';
2 %put cntry resolves to &cntry ;
3
4 %if %upcase(&cntry.) in OMAN,CHINA %then %let like_cntry=%bquote('&cntry.%');
5 %else %let like_cntry=%sysfunc(compress(%bquote('% &cntry.%'),%str( ))) ;
6
7 %put like_cntry resolves to &like_cntry.;
8 %mend;
9 %em(cntry=japan)
cntry resolves to japan
like_cntry resolves to '%japan%'
10 %em(cntry=china)
cntry resolves to china
like_cntry resolves to 'china%'