Create a new variable that captures the order of another variable

[lola_rodriguez]

Hi all, 

I have a datasets that contains movies and how many people have watched it. 

I would like to create a new variable (Position) that Position=1 if that movie is the most streamed, Position=2 if that movie is the second most streamed movie, etc...

[maguiremq · Accepted solution]

PROC RANK is probably best here. If a movie has the same amount of views, what do you want to do with ties?

[lola_rodriguez]

Thank you very much! @maguiremq