BookmarkSubscribeRSS Feed
Sheharyar24
Calcite | Level 5

Please can you tell me how can I make a table following the description below (PDF attached pg 21, 22 containing the table i want to replicate). I want the commands, to sort them out first on the basis of past returns(losers, Neutrals, winners) and then further sorting them into sizes and in the end get the table with the p1,p2,p3(three return portfolios) on the left hand side and sizes s1,s2....s10 in the upper column and then returns in the centre with t values. I have attached the pdf file which will show the exact table follwoing this description, table which i want is on page 21,22. I will really be grateful. Thanks in advance.

Momentum Strategies Based on Raw Returns and Sorted by Size (1980-2004)

This table reports the average monthly returns of momentum portfolios formed based on the previous K

months’ raw returns and held for K months (K=3, 6, 9,and 12). Each month, NYSE and AMEX

stocks are ranked in ascending order based on the lagged returns and divided into three equal-weighted

portfolios. Portfolio P1 is formed by the loser stocks and P3 is formed by the winner stocks over the

previous K months. This table presents the time-series average monthly returns of holding these

portfolios for K months. On the other hand, stocks are sorted into ten portfolios each month based on

their previous capitalizations. Portfolio S1 includes the smallest firms and S10 includes the largest

firms. Within each decile, firms are equally sorted into three portfolios (P1 to P3) based on their lag

raw returns. This table also reports the time-series average monthly return of holding these portfolios

in each size class for K months. Median sizes are in millions and t-statistics are in parenthesis.

1 REPLY 1
Patrick
Opal | Level 21

There are at least 2 questions here. 1) How do I calculate all these measures, 2) How do I create a report over this measures in the required format

A lot of people in this forum here are very supportive in helping to you to get over obstacles when you get stuck in your work. It's another story when it comes to doing your job for you - and this is what you're asking for here.

I suggest that you get started in solving your problem and come back here when you're facing issues with some concrete problems. If so then post a data step which creates sample data, all the code you've already developed and then explain where it doesn't work and how the result should look like.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 856 views
  • 0 likes
  • 2 in conversation