How about :
gen revenue_reversed = revenue * -1
sort revenue_reversed
egen rank=group(revenue_reversed)
Jeremy
On 02/03/2008, Song <[email protected]> wrote:
> Dear Statalisters,
>
> I am trying to create 'rank' based on total revenues. I used the following
> command:
>
> sort revenue
> egen rank=group(revenue)
>
> The result is that the smallest revenue is 1 and the highest revenue is 100,
> for example. How can I reverse the rank? I want the highest revenue to be
> number '1'.
>
> Thank you,
> Reo.
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
--
Jeremy Miles
Learning statistics blog: www.jeremymiles.co.uk/learningstats
Psychology Research Methods Wiki: www.researchmethodsinpsychology.com
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/