Uneven rank groups

littlewho — Sun, 05 Jul 2020 11:59:11 GMT

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!

Re: Uneven rank groups

Ksharp — Sun, 05 Jul 2020 12:25:34 GMT

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 ;

topic Re: Uneven rank groups in SAS Programming

Uneven rank groups

Re: Uneven rank groups