Uneven rank groups

[littlewho]

Hello,

I am trying to rank a dataset's variable using 3 groups, but I want the groups to be distributed as following:

- rank 0 -> 0 to 10% of observations

- rank 1 -> 10% to 20% of observations

- rank 2 -> the rest up to 100%

I know that by default "proc rank groups = 3" would split the dataset into 3 equal groups. Could anyone point me into the right direction?

Thanks!

[Ksharp · Accepted solution]

proc rank groups = 10
NEW_GROUP
- rank 0 -> 0 to 10% of observations if rank=0 then new_group=1;
- rank 1 -> 10% to 20% of observations else if rank=1 then new_group=2;
- rank > 2 -> the rest up to 100% else new_group=3 ;