BookmarkSubscribeRSS Feed
MarinaMag
Fluorite | Level 6

Hello,

 

I want to use daily returns from crsp, regress them on market return and obtain the residuals of the annual regression to estimate the firm specific volatility and skewness of each firm.

I need each firm to have at least 200 observation available each year (ie from 252 trading days).

I have to work remotely on wrds because the dataset of daily stocks its huge.

Can anyone help me?

 

Thank you,

1 REPLY 1
mkeintz
PROC Star

I  presume you want the CRSP daily stock  file (crsp.dsf).  What are the variable names in crsp.dsf that  you want?   And what are the variables names in crsp.sp500 that you want?    [edit]:  Or what variables from crsp.dsi   (index daily dataset).

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 1 reply
  • 1019 views
  • 0 likes
  • 2 in conversation