Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: cutpoints for deciles
From
"Fabian Schönenberger" <[email protected]>
To
[email protected]
Subject
st: cutpoints for deciles
Date
Tue, 10 Jul 2012 13:44:00 +0200
Dear Statalist
I am working with a broad panel set consisting of companies (id) and observations for different point-in-times (t) of different variables (var). My goal is to assign each company to a decile according to its market capitalization on a yearly basis. Instead of forming equally distributed portfolios with xtile2 (Stata module by Wang), I want the assignment based on 10 cutpoints of the market capitalization.
For example: If in year 1 the smallest company is 200, the largest 2000, there are the following cutpoints: 200,380,560,740,920,1100,1280,1460,1640,1820,2000. A company with market capitalization of 250 should be in portfolio 1, one with 1900 market capitalization in portfolio 10.
I have found the cutpoints option of xtile. However, I do not have the cutpoints in a separate variable.
How do I have to proceed? First creating the cutpoints and then xtile? Or is there a more direct approach?
Many thanks for your support!
Fabian
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/