Dear everyone,
I have a data set containing daily stock prices and I would want to calculate the annual abnormal stock returns. To get the annual abnormal stock returns, I need to subtract the annual average stock returns from the returns of the individual stocks. My data looks like this:
GVKEY DATADATE AJEXDI PRCCD TRFD
002721 19901227 1.0377 0.3000 1.2415953
stock return=(((((PRCCD/AJEXDI)*TRFD)/((PRCCD(PRIOR)/AJEXDI(PRIOR))*TRFD(PRIOR))) -1 )* 100).
I would be very grateful if someone could help me the code.
Thanks
Is this not covered in one of the 600 posts returned by a search:
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.
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.