topic Re: Rank procedure in SAS Software for Learning Community

Rank procedure

Lilik — Wed, 19 Mar 2025 11:04:24 GMT

Good day dear All,

I am new here. Taking SAS courses and have a question regarding the Rank procedure. The thing is, when I'm using it my ranking values are not integres.

I want to rank the goals quantities in order to find the second highest values of each category.

proc rank data=LaLiga out=rankings;
var goals;
ranks result;
proc print data=rankings;
run;

why it doesn't work here?

thanks in advance.

Re: Rank procedure

JackieJ_SAS — Wed, 19 Mar 2025 11:46:55 GMT

Hi, The ranks are not integers, because of the ways tied values are being handled. When you have more than one observation with the same data value, the default is for PROC RANK to compute the mean of the ranks.

Try out different values of the TIES= option on the PROC RANK statement, and see which one gets what you want:

https://go.documentation.sas.com/doc/en/pgmsascdc/v_060/proc/p16s2o8e4bnqrin1phywxdaxqba7.htm#n128utp0vvfmlrn1lr0nbu0kf6nu

Since it looks like this is data where a higher number of goals is better, also consider using the DESCENDING option.

Re: Rank procedure

PaigeMiller — Wed, 19 Mar 2025 12:41:30 GMT

I want to rank the goals quantities in order to find the second highest values of each category.

If "category" means Position, then you want to make position a BY variable.

proc sort data=have;
    by position;
run;
proc rank data=have out=rankings descending ties=low;
    by position;
    var goals;
    ranks goals_ranked;
run;

As stated, you will have to figure out which option of TIES= works best for you.

If you don't care about ties, then just sort the data by position and goals, and take the 2nd record for each position.

Re: Rank procedure

Ksharp — Thu, 20 Mar 2025 02:08:34 GMT

proc rank data=have out=rankings descending ties=dense;

Re: Rank procedure

Lilik — Thu, 20 Mar 2025 06:26:58 GMT

Thank you for your help.

Re: Rank procedure

Lilik — Thu, 20 Mar 2025 06:27:17 GMT

Thank you for your help.

Re: Rank procedure

Lilik — Thu, 20 Mar 2025 06:28:22 GMT

Thank you.