Hi All,
I am trying to rank observations based on a specific percent i.e. if the percentage is less than 10%, the observation belongs to rank 1; if less than 20% and more than 10% to rank 2, and so on. So, I cannot use proc rank in this case. I can write it with sql and case, like
case
when percent le .1 a
when percent gt .1 and percent le .2 b ; ...
but it seems to me that it is inefficient and there must be a better way.
Can anyone please let me know if there is a more straight way of doing this?
Thanks a lot!