Janneke,
It sounds like you want the -xtile- command, which categorizes each observation by the percentile it falls in.
Hope this helps.
Howie
Howie Lempel
Research Assistant
The Brookings Institution | Economic Studies
1775 Massachusetts Ave NW | Washington DC 20036
[email protected] | p: (202) 238-3576
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Janneke Pieters
Sent: Thursday, February 19, 2009 8:52 AM
To: [email protected]
Subject: st: help with pctile
Dear users,
I want to generate 100 percentiles for a variable called cmpce. These
will be used later to calculate the mean of cmpce for each percentile.
In Stata10 I type:
pctile percentile = cmpce [pweight = weight], nquantiles(100) genp(pctile)
The new variables percentile and pctile only have a value for the first
100 observations in my data, and a missing value for the other 102257
observations. Is something wrong with my command?
Thanks in advance,
Janneke Pieters
*
* 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/
