BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Astounding
PROC Star

It was a good year, but it shouldn't be that good.

 

Calculations come out to 91.8%

 

Questions to consider:

 

  • Is this the first ticker/year in the data?  (If not, what was in the observation just prior to this?)
  • Are the RET values verified from the SAS data set, vs. from another source that was imported into SAS?  There might be a need to verify what is in the SAS data set for those months.
sastuck
Pyrite | Level 9

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!

Astounding
PROC Star

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).

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 32 replies
  • 1849 views
  • 5 likes
  • 4 in conversation