topic Re: Exponential calculation in SAS Programming

Exponential calculation

deleted_user — Thu, 30 Oct 2008 09:00:33 GMT

I am trying to perform the following Excel function in a SAS data step

=0.3751*(31640/5/60)^-0.4988

But SAS doesn't like the following part of the calculation when I try to duplpicate

'^-0.4988'

Any ideas of how I can duplicate the calculation?

Thanks

Re: Exponential calculation

deleted_user — Thu, 30 Oct 2008 09:07:54 GMT

Forgot to say that the result from the Excel based calculation is

1,162.12

Re: Exponential calculation

LinusH — Thu, 30 Oct 2008 14:52:15 GMT

Exponential calculation is performed in SAS using double asterisks (**).
But I am having trouble getting your result. Both in Excel and SAS I'm getting 0.036729684...?

/Linus

Re: Exponential calculation

deleted_user — Thu, 30 Oct 2008 15:07:09 GMT

Sorry...I messed another bit of the Excel calculation. But yours is correct and got the data step to work.

Thanks