Proc rank

[JPARK]

Hi,

I am trying to rank a variable to 4 (quartile)and 10(decile).

However, when I checked my data, there are only 4 and 9 for the decile ranking.

and 1 and 3 for the quartile ranking.

A lot of observations have 0 values. It might be the reason that I am only getting 1 and 3 ranks for quartile and 4 and 9 for decile.

Do you know why?

proc rank data=a groups=10 out=a_Q10;

var b;

ranks c;

run;

Thank you!

[Reeza]

Because as you've indicated you probably have a lot of 0's.  So some of your "ranks" are probably the same.

[Rick_SAS]

Sounds like many repeated values. See Binning data by quantiles? Beware of rounded data - The DO Loop