topic Re: sum of macro variables in SAS Programming

sum of macro variables

VISHNU239 — Wed, 11 Jul 2018 17:21:01 GMT

Hi, I have two macro variables &a and &b. I have to sum these two macro variables and assign it to other macro variable name &c. How do I do that? Please help me.

Re: sum of macro variables

Kurt_Bremser — Wed, 11 Jul 2018 17:27:31 GMT

Use %eval:

%let c = %eval(&a+&b);

Re: sum of macro variables

LinusH — Wed, 11 Jul 2018 17:27:42 GMT

Take a look at %eval.

Re: sum of macro variables

PaigeMiller — Wed, 11 Jul 2018 17:38:42 GMT

%eval works only on integers. If &b has a value of 7.5, you get an error. In that case, you could use %sysevalf

but you'd still be better off doing anything more advanced than integer arithmetic in a data step

Re: sum of macro variables

VISHNU239 — Wed, 11 Jul 2018 17:36:03 GMT

a and b will have decimal values too. can you help me the statement for that part too?

Re: sum of macro variables

Reeza — Wed, 11 Jul 2018 17:37:28 GMT

He did, %SYSEVALF.

Re: sum of macro variables

PaigeMiller — Wed, 11 Jul 2018 17:39:02 GMT

@VISHNU239 wrote:

a and b will have decimal values too. can you help me the statement for that part too?

Do the math in a data step

Re: sum of macro variables

novinosrin — Wed, 11 Jul 2018 17:46:42 GMT

%let a=1.4;
%let b=1.6;

%let c=%sysevalf(&a+&b);

%put  &=c;

Re: sum of macro variables

VISHNU239 — Thu, 12 Jul 2018 03:38:54 GMT

Thanks guys. it worked.