Excel formula to SAS - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

Excel formula to SAS

Posted 04-07-2015 01:44 PM (1056 views)

HHi ,

i have a formula in excel

= (50/-10000) *30.4/(Z2-Y2)

when eh we work on dec data Z2-Y2 shd be nov - sep

sso the result shd be 30 days

can anyone help

1 REPLY 1

Super User

Super User

Re: Excel formula to SAS

Posted 04-07-2015 01:47 PM (980 views) | In reply to chennupriya

This would depend on your data structure, but in general the formula is exactly the same. Substitute the variable names in place of Z2 and Y2.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!