Convert variable to percentile

[Gary Zhang]

How can I convert values of a variable to percentiles ranging from 1-99?

I have tried pctile but it does not give the correct results.

[Liu Qiang]

Hi Gary, can you first list the incorrect example with pctile first?

[Gary Zhang]

Hi, I am trying the example on page 3 here:

https://www.stata.com/manuals13/dpctile.pdf

How do I get it to create a variable that shows for example, the observation with mpg = 41 to be 100th percentile, and observation with mpg = 12 to be 0 percentile?
Thanks.

[Liu Qiang]

Your request is very strange. Can you first define what a 0 percentile is?

[Gary Zhang]

Sorry, I meant from 1 to 99.

[Igor Paploski]

Hi Gary, try:

xtile newvar = oldvar,nq(100)

[Gary Zhang]

Hi Gary, try:

xtile newvar = oldvar,nq(100)

Yes the results look correct now. Thanks

[Nick Cox]

See also https://www.stata.com/support/faqs/s...ing-positions/