Rank coming in decimal

Srigyan — Tue, 10 Apr 2018 11:52:52 GMT

I have getting this output by below code data,

I am getting above ranking by below code, I am not expecting rank as 2.5, it should be 1 in all the case as it is based on col-2 and group by col-1.

code is

proc rank data= have out = want;
var col-2;by col-1;
ranks ranking;

run;

can someone tell me why this is coming as 2.5 and how to correct it.

Re: Rank coming in decimal

Astounding — Tue, 10 Apr 2018 12:23:33 GMT

Add to the PROC RANK statement:

ties=low