topic Re: How to evaluate expression in SAS Programming

How to evaluate expression

kishore415 — Tue, 22 May 2012 06:19:00 GMT

Hi..

I have arithmetic expressions in a character field in a dataset as below...

example:

exp

701*10 ** 6

460*10 ** 6

6.22 * 10**-4

2*10**-3

Am unable to evaluate the expressions and keep them in a numeric variable..Can anyone please help me in this regard..

Thanks

Re: How to evaluate expression

LinusH — Tue, 22 May 2012 06:50:17 GMT

I suggest that you use the Call Execute routine for this.

Re: How to evaluate expression

Ksharp — Tue, 22 May 2012 06:51:46 GMT

How about:

data have;
input exp $20.;
cards;
701*10 ** 6
460*10 ** 6
6.22 * 10**-4
2*10**-3
;
run;
data want;
 set have;
 result=resolve(cats('%sysevalf(',exp,')'));
run;

Ksharp

Re: How to evaluate expression

LinusH — Tue, 22 May 2012 06:59:48 GMT

Neat!

Re: How to evaluate expression

Ksharp — Tue, 22 May 2012 07:09:41 GMT

LinusH,

You still didn't go to sleep ?

At Sweden , It should be very late.

But At China, It is afternoon.

Ksharp

Re: How to evaluate expression

LinusH — Tue, 22 May 2012 07:13:35 GMT

I had sleep, but is 9 AM in sweden right now, and I 'm back to work! Thanx for your concern...

Re: How to evaluate expression

MikeZdeb — Tue, 22 May 2012 14:51:15 GMT

Hi ... great solution. One extra thing, I think the poster wants a numeric result ...

"Am unable to evaluate the expressions and keep them in a numeric variable"

So maybe ...

data want;

set have;

result=input(resolve(cats('%sysevalf(',exp,')')), 12.);

run;

Re: How to evaluate expression

Ksharp — Wed, 23 May 2012 02:39:29 GMT

You are welcome. In fact , this skill I learned is from this Forum .