It was a good year, but it shouldn't be that good.
Calculations come out to 91.8%
Questions to consider:
How can I use this code to calculate the geometric mean of the monthly values instead? (which takes several values and multiplies them together and sets them to the 1/nth power). Thanks for the help!
If memory serves, we never adjusted the program for tickers that did not end with a valid value in month 12. That should be added in where the current statement reads:
if month=12;
That should become:
if month=12 or last.ticker;
This wouldn't affect the first ticker. While it's hard to imagine a ticker coming before AA, I believe Agilent (A) comes before Alcoa (AA).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.