I think what you want is -xtile-:
. xtile percentile = cmpce[pweight=weight], nq(100)
will create a variable -percentile- which categorizes
every value of cmpce according which percentile (1-100)
it falls in.
hth,
Jeph
Janneke Pieters wrote:
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/