Date:         Thu, 30 Oct 2008 03:18:49 -0700
Reply-To:     karma <dorjetarap@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         karma <dorjetarap@GOOGLEMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Exponential Calculation
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 30 Oct, 09:53, mikeymay <mikey...@gmail.com> wrote:
> I am trying to perform the following Excel function in a SAS data step
>
> =0.3751*(31640/5/60)^-0.4988
> Returning 1,162.12
>
> 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

Hi Mikey,

The "^" character in SAS means the truth evaluation "not". In Excel
this is to raise a number to a power, the equivelent in SAS is "**".
0.3751*(31640/5/60)**(-0.4988).

I don't think the result you provided is correct. This calculation
returned 0.036 (to 3dp) in both Excel and SAS.

HTH