topic Not getting required bins in Proc Rank in SAS Programming

Not getting required bins in Proc Rank

Stuti_ — Tue, 06 Dec 2022 12:16:01 GMT

Hi,

I am using the following code to create decile for my data:
proc rank data = s1 out=s1 groups=10 descending ; var WOE_R10 ; ranks WOE_R10_rnk; run;
But instead of getting 10 ranks, I am only getting 3. Can anyone explain the reasoning for this?

Re: Not getting required bins in Proc Rank

PaigeMiller — Tue, 06 Dec 2022 12:23:31 GMT

Most likely, you have ties in your data and so this variable cannot be split into 10 groups, it can only be split into 3 groups.

Or possibly, the variable has only 3 non-missing values.

Re: Not getting required bins in Proc Rank

Stuti_ — Tue, 06 Dec 2022 13:50:39 GMT

It does have only 3 value distribution but the ranking is 0 and 5. Shouldn't it be 0,1,2?

Re: Not getting required bins in Proc Rank

PaigeMiller — Tue, 06 Dec 2022 13:53:49 GMT

@Stuti_ wrote:
It does have only 3 value distribution but the ranking is 0 and 5. Shouldn't it be 0,1,2?

Apparently not.

Re: Not getting required bins in Proc Rank

Stuti_ — Tue, 06 Dec 2022 14:22:14 GMT

Can you explain why?

Re: Not getting required bins in Proc Rank

ballardw — Tue, 06 Dec 2022 15:39:43 GMT

@Stuti_ wrote:

Hi,

I am using the following code to create decile for my data:
proc rank data = s1 out=s1 groups=10 descending ; var WOE_R10 ; ranks WOE_R10_rnk; run;
But instead of getting 10 ranks, I am only getting 3. Can anyone explain the reasoning for this?

Example data. One suspects massively tied data.

This example only has 3 ranks because there are only 3 values in the data. You get "ranks" other than 0,1,2 based on tie breaking rules.

data example;
  do i=1 to 15;
     do val = 1, 3,5;
     output;
     end;
  end;
run;

proc rank data = example out=ex2 groups=10 descending ;
   var val ; 
   ranks val_rnk; 
run;