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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.