topic Re: Proc rank in SAS Programming

Proc rank

JPARK — Wed, 07 Jan 2015 22:33:55 GMT

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 — Wed, 07 Jan 2015 22:55:31 GMT

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

Rick_SAS — Fri, 09 Jan 2015 13:41:13 GMT