topic concatenate a macro variable with single quote in SAS Programming

concatenate a macro variable with single quote

bhu — Thu, 14 Feb 2019 23:06:14 GMT

I have a macro variable which I first need to convert it to a number and do some mathematical calculation, then I have to cover it with a single quote and bracket.

%let num1= 1000;
%let num2= 1000 - 100;
%let output = ('&num1.','&num2.');

I need output like this:

('1000','900')

Re: concatenate a macro variable with single quote

bhu — Thu, 14 Feb 2019 23:13:37 GMT

I found the solution:

%let num1 = '1000';
%let num2 = %sysevalf(%sysfunc(compress(&num1.,"'"))-10);
%let output = (&num1.,%tslit(&num2.));
%put &num1.;
%put &num2.;
%put &output.;

Re: concatenate a macro variable with single quote

Ksharp — Fri, 15 Feb 2019 12:02:13 GMT

%let num1= 1000;
%let num2= 1000 - 100;
%let output = (%bquote('&num1.','%eval(&num2.)'));

%put &output ;

Re: concatenate a macro variable with single quote

novinosrin — Fri, 15 Feb 2019 14:21:54 GMT

Hey Xia @Ksharp

I know too well that you are intelligent. But unfortunately i am not,so

Can you please give me a hand to help my understanding if you have a couple of mins

Does the %bquote here force macro resolution inside '&var' and then quote the value? Is this behavior consistent?

I am keen to understand how the macro processor works here.

Sorry for the bother if you are busy

Re: concatenate a macro variable with single quote

Ksharp — Sat, 16 Feb 2019 12:01:02 GMT

Hi. Thanks everything you do for sas communitity.

"Does the %bquote here force macro resolution inside '&var' and then quote the value? Is this behavior consistent?"

Answer is no. As far as I know %bquote firstly mask single quote , since quote has been masked ,then resolving macro variable & var is nature thing ,as %let x=&var ; .did .

Hope this could give you some hint .