topic Re: How to get expression value in SAS Programming

How to get expression value

deleted_user — Thu, 27 Aug 2009 15:45:27 GMT

I have a dataset with two variables and three observation as following.

Formula($200.) Value(Best20.2)
netpv(0.1, 1,0, 1000)
sin(45)
netpv(0.1,1,0, netpv(0.1,1,0,2000)

How to calculate formula variable and update the result to value variable. Thanks all master-hand first!

Re: How to get expression value

Flip — Thu, 27 Aug 2009 16:05:10 GMT

is this what you mean?

data _null_;
set xxx end = eof;
if _n_ = 1 then
call execute('data new; set xxx;');
call execute('if formula = "' || formula ||'" then value = ' ||formula || ';');
if eof then call execute('run;');
run;

Re: How to get expression value

data_null__ — Thu, 27 Aug 2009 16:08:24 GMT

This will be slow and it doesn't handle nested functions.

[pre]
data results;
input formula $40.;
value = input(resolve(cats('%sysfunc(',formula,')')),f8.);
cards;
netpv(0.1, 1,0, 1000)
sin(45)
netpv(0.1,1,0,2000)
;;;;
run;
proc print;
run;
[/pre]

Re: How to get expression value

deleted_user — Thu, 27 Aug 2009 16:40:15 GMT

You are my God, thank you very much!