Hey Dear members,
I'd like to construct with my Data sets in the Attachments 10 equally weighted decile Portfolios, which are ranked on the past 3 year volatility. what i've done yet is to rank and create a colomn on my data named volatility like you can see on my SAS Code. But the data inside are again the data from my Excel that mean from LogReturn, so my Question now is how to calcul the volatility of each firm and rank all this result on the past 3 year volatility by generating 10 equally weighted Decile Portfolios. Thanks for your Help in Advance!
FILENAME REFFILE '/folders/myshortcuts/MyFolders/SaS_Stoxx300.xlsx';
PROC IMPORT DATAFILE=REFFILE
proc sort data=work.import(keep=_numeric_);
out=work.transposed(rename=(_label_=Firm Volatility1=Volatility) where=(not missing(Volatility)) drop=_name_)
proc rank data=work.transposed groups=10 descending out=work.ranked;
proc sort data=work.ranked;
by date decile;
proc print data=work.ranked;
Hi Ksharp, to come back on your Question , i understand now what you mean, on my Excel data we have the LogReturn, the second step should be to calculate the volatility of all this data, then use a Code to sort all the data into equally weighted decile Portfolio, that means on my example with 303 firms , after sorting we'll have 10x30 and each decile will have 30 Firms having data of volatility. i have added the Excel data in the Attachments to Show you how my data will look for after sorting. PS: the data inside my tables are not correct just selected for me like example.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.