BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Does anyone now how to use the IRR function in SAS?

Here's an example of a cash flow that I used:
Month1: $-3,000
Month2: $600
Month3: $1,200
Month4: $600
Month5: $700

In excel I use the IRR function (=IRR(-3000,600,1200,600,700,.01)) and get a monthly IRR of 1.35%.

In SAS I use the IRR function (monthly_irr=IRR(5,-3000,600,1200,600,700)) and get a monthly IRR of 6.93. INTRR gives .0693.

Does anyone know how to use the SAS IRR function to get 1.35%? In support.sas it says that IRR should be written IRR(frequency,cash1,cash2,...,cashn).

Thanks for the help!!!
3 REPLIES 3
deleted_user
Not applicable
are you expecting the IRR per period or per year?
A first order approximation indicates (SAS Result)/frequency approx= (excel result)

I guess you might need to check on the excel doc, too

PeteC
deleted_user
Not applicable
Hi Pete,

Thanks for the help. My periods are months so I'm looking for it by period and annualy. I thought that the function did it by period as it asks for frequency and then i used this calculation to change it to annual.

annual_irr=((monthly_irr+1)**12)-1;

Thanks again for the help!
Laura
deleted_user
Not applicable
you'll find the SAS doc for function INTRR() more helpful, as it includes an example that might clarify the purpose of the FREQ parameter.... see http://support.sas.com/documentation/cdl/en/lrdict/59540/HTML/default/a000245903.htm.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2402 views
  • 1 like
  • 1 in conversation