BookmarkSubscribeRSS Feed
joshdella3
Calcite | Level 5

data WORK.PORT_SAS1;

input acc:BEST12. year:BEST12. month:BEST12. isin:$12. stockValue:BEST12. sumStockValue:BEST12. ret:32. id_vol:32. id_skew:32. exp_skew:32.;
format acc BEST12. year BEST12. month BEST12. stockValue BEST12. sumStockValue BEST12.;
label ret="ret" id_vol="id_vol" id_skew="id_skew" exp_skew="exp_skew";
datalines;
6464 1996 9 FI0009000053 1516.8 14503.3 0.0070707072 0.014095664 -0.409987509 -0.101588927
6464 1996 9 FI0009000285 2834 14503.3 -0.037383176 0.028269276 -0.125411317 1.0177152157
6464 1996 9 FI0009000202 2572.5 14503.3 0.0054794522 0.0130039575 1.1602475643 0.402938664
6464 1996 9 FI0009000707 7580 14503.3 0.0099009899 0.0219429601 0.5999519825 -0.269438356
6464 1996 10 FI0009000285 2678 15002.2 -0.029990628 0.0273272116 0.3355706632 0.499995023
6464 1996 10 FI0009000202 2569 15002.2 -0.007092199 0.0136819324 0.9428936243 0.3203088343
6464 1996 10 FI0009000707 8160 15002.2 0.0338164233 0.0213803966 0.6024077535 0.128086552
6464 1996 10 FI0009000053 1595.2 15002.2 0 0.0133521734 -0.262459815 0.0332798772
;
run;

 

Hey, 

 

I have a data set (excerpt above) which includes observations at the investor, stock, month level. 

I'm looking to calculate the idiosyncratic vol (ID_Vol), idiosyncratic skewness (ID_Skew) and expected skewness (Exp_Skew) of the portfolios each month. 

I have calculated the respective values at the asset level (attached) but I am having difficulties calculating the values at the portfolio level as I'm not calculating co-variance and co-skewness for a multiple asset portfolio correctly. 

 

Thus, how do I calculate the co-variance and co-skewness of the assets such that I can then calculate the respective values for the portfolios?

 

Thanks in advance. 

 

 

 

 

 

 

 

1 REPLY 1

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 430 views
  • 1 like
  • 2 in conversation