# st: AW: Dividing Panel data into quartiles

 From "Martin Weiss" To Subject st: AW: Dividing Panel data into quartiles Date Thu, 16 Apr 2009 18:09:19 +0200

```<>

You want to check carefully whether this does what you want. At the very
least, it contains some useful techniques if you do decide to waste
information... How low can liquidity go? I assumed 0...

*************
clear*
local obs 10000
set obs `obs'
egen float firmid = seq(), from(1) to(`obs') block(10)
egen float year = seq(), from(1) to(10) block(1)
gen byte
industry=irecode(runiform(),0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1)

bys firmid: g liquidity =20000+rnormal()*10 if _n==1
bys firmid: replace liquidity=liquidity[_n-1]+rnormal()*10 if _n!=1

forv i=25(25)75{
bys year industry: egen pctile`i'= pctile(liquidity) , p(`i')
}

bys year industry: gen quartile=irecode(liqui, 0,
pctile25,pctile50,pctile75)

sort firmid industry year
//l, noo sepby(firm indu)

// if you want to get rid of pctile, comment out below
// drop pctile??
*************

HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von JIBONAYAN
RAYCHAUDHURI
Gesendet: Donnerstag, 16. April 2009 17:18
An: statalist@hsphsun2.harvard.edu
Betreff: st: Dividing Panel data into quartiles

Hi, Statalistusers,

I have a panel data set, with data on a number of
firms over a number of years. Each observation is
for a particular firm and year, and has various data
for that observation. The firms are classified by a two
digit industrial classification scheme called NIC2.

I would like to divide my data into 4 quartiles or 5
quintiles, on the basis of one of my variables,
liquidity. So I would like to create a variable, call it
quartile, that has the value 1 if that observation for the
firm  is in the top quartile of liquidity for that year for that
industry, has the value 2 if that observation is in the second quartile
of liquidity for that year and industry, etc. (a firm
might have different values of "quartile" in different
years, depending on which quartile of liquidity it fits
into in a particular year. The quartiles will probably
contain somewhat different firms in each year.)
The complication is that I want the firms divided
into quartiles for each year and also each industry. I
think  the command xtile would probably work here
to divide firms into quartiles, but I am not sure as to how
the code would have to  work to get all firms in a year sorted
by industry and then divide them into quartiles, although it seems
like it should be simple.

Thanks in advance for any help!

Jibonayan

*
*   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/

*
*   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/
```