topic Urgent help! with assignment of sorting portfolios in SAS Programming

Urgent help! with assignment of sorting portfolios

emilykingjr — Thu, 28 Jan 2016 19:11:40 GMT

Hi everyone,

I am now in a seminar of advanced investments, where i have an assignment of sorting the portfolios and construct the investing strategy based on momentum and volatility. However, I don't know anything about programming and I was told that SAS is the only the program that can do this assignment. I know this is a very troublesome question, as i need help from the very beginning with SAS...

Here is the code for creating momentum that my teacher gave us. and we need to do something similar for the variance ( a proxy for volatility). And how shall i do it?

data stkid;
set work.example;
yearmth=year*12+12-month;
run;
keep stock code year month yearmth;
retyearmth=year*12+12-month;
run;

data ret;
set work.example;
keep stock_code year month retyearmth return;
run;

proc sql ;
create table data as select *, log(b.return+1) as logretfrom stkid as a,ret as b
where a.stock_code=b.stock_code and (yearmth-12)<=b.retyearmth<=(yearmth-2);
quit;

proc sort data=data;by stock_code yearmth;
run;

proc means

Also here are the codes for the major steps of the assignment, single sorting and double sorting. But don't know how to use it...

My variable name are: stockid, yearmonth, return.

https://sites.google.com/site/jiejaycao/home/tools1. SAS with SQL

I really tried to learn it by myself from all the materials online, but i am afraid this is really not my area. I relly run out of options so that's why i come here to ask this big question, hoping someone can help me work out the whole code, actually the main connections. I shall be more than grateful!

Re: Urgent help! with assignment of sorting portfolios

mohamed_zaki — Thu, 28 Jan 2016 19:32:56 GMT

I can not follow you....

What do you want to do you want us to help you with exactly?

Be specific with what you need.

Give sample data and say how you want it to be, so we can help...

Re: Urgent help! with assignment of sorting portfolios

emilykingjr — Thu, 28 Jan 2016 19:56:07 GMT

Hello Mohamed,

The data is too big, so I will not upload it, but it looks like this:

time stockid return

200501 123 0.55

200502 123 -0.01

200501 234 0.09

200502 234 0.08

So it is a panel data, with around 500 stocks' monthly return in around 10 year's time. And the time format in the raw data is year together with month.

The assignment is to create and test two investing strategies based on momentum and volatility. Momentum will be the return of a stock of the past 12 month minus the past 1 month. So for example, the momentum for stock 123 in 200501 will be its cumulative return during 200401-200412. The proxy for volatility will be the variance, which is calculated based on the past 3 years. For example again, the volatility for stock 123 in 200501 will be calculated using the returns from 200201-200412.

Firstly I need to construct the two measures in my data set, then I need to follow the first two steps in the link (winsorize, single sorting). The macros are already there, but I do not know how to connect them... I would appreciate your help very much!