Confusion with Rankings

[Jonny Klause]

Hello,
I am working on a dataset for my class where we are looking at the top 50 songs in the country. However, Stata recognizes that #50 is the best and #1 is the worst. How can I fix this where stata understands that of the 50 songs shown, #1 is the best and #50 is the worst for that list.

[Jared Greathouse]

In code

delimiters, please use the dataex command to present your data and the code you've tried so far.

[Nick Cox]

Negation of the variable you feed will reverse rankings.

[Nick Cox]

This is documented in the manual entry [D] egen.

[Leonardo Guizzetti]

Hello,
I am working on a dataset for my class where we are looking at the top 50 songs in the country. However, Stata recognizes that #50 is the best and #1 is the worst. How can I fix this where stata understands that of the 50 songs shown, #1 is the best and #50 is the worst for that list.

While it may seem unintuitive, statisticians conventionally use this interpretation of ranks in notation. It doesn’t harm the math, but sometimes it is not what is expected.