DATA Step, Macro, Functions and more

Exponential calculation

Reply
N/A
Posts: 0

Exponential calculation

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
N/A
Posts: 0

Re: Exponential calculation

Posted in reply to deleted_user
Forgot to say that the result from the Excel based calculation is

1,162.12
Super User
Posts: 5,430

Re: Exponential calculation

Posted in reply to deleted_user
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
Data never sleeps
N/A
Posts: 0

Re: Exponential calculation

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


Thanks
Ask a Question
Discussion stats
  • 3 replies
  • 115 views
  • 0 likes
  • 2 in conversation