Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Quintile count based on population breakpoints on event date

From   Imtiaz ul Haq <>
Subject   st: Quintile count based on population breakpoints on event date
Date   Thu, 30 Aug 2012 16:38:33 +0100


I'm trying to count the number of name-change companies in quintiles
based on breakpoints obtained from the characteristics of the universe
of all companies. For each name change event, the quintiles
breakpoints should be determined relative to all other companies on
the event date. This is what my data looks like:

Date               Company ID        Return               Name_change event

2001/01                    1                     0.034
2001/02                    1                     0.121
2001/03                    1                     0.048
2001/02                    2                     0.107
2001/02                    2                     0.092
2001/03                    2                     0.109
2001/01                    3                     0.082
....                               ..                      .....

I want see how many name change companies fall into each 5 quintiles
(the quantiles are based on the universe of companies on event date).
This is to get an idea of how name-change companies are distributed.
Essentially I want this information:

                                       Q1       Q2       Q3      Q4
Returns distribution for name-change companies                     19
       21       7          8           3

I have over 10,000 companies, and I am confused as to what is the best
way to go about doing this in Stata.

Imtiaz ul Haq
*   For searches and help try:

© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index