topic Create a new variable that captures the order of another variable in SAS Programming

Create a new variable that captures the order of another variable

lola_rodriguez — Mon, 18 Jul 2022 10:27:17 GMT

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...

Re: Create a new variable that captures the order of another variable

maguiremq — Mon, 18 Jul 2022 11:04:55 GMT

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

Re: Create a new variable that captures the order of another variable

lola_rodriguez — Tue, 19 Jul 2022 07:50:41 GMT

Thank you very much! @maguiremq