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!
Because as you've indicated you probably have a lot of 0's. So some of your "ranks" are probably the same.
Sounds like many repeated values. See Binning data by quantiles? Beware of rounded data - The DO Loop
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.