Rank procedure

[Lilik]

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.

[JackieJ_SAS]

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

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

[Lilik]

Thank you.

[PaigeMiller · Accepted solution]

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.

[Lilik]

Thank you for your help.

[Ksharp]

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

[Lilik]

Thank you for your help.