As mentioned in my earlier posting, this fixes the reversal but does the
wrong thing in the presence of ties.
For ranks, use -egen, rank()-. It's as simple as that.
Nick
[email protected]
Jeremy Miles
How about :
gen revenue_reversed = revenue * -1
sort revenue_reversed
egen rank=group(revenue_reversed)
Song
> 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'.
*
* 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/