Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[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!

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index