topic Ranking Output and then grouping the remaining in New SAS User

Ranking Output and then grouping the remaining

new_sas_user_4 — Fri, 23 Nov 2018 18:21:18 GMT

I used order by to order my randomly arranged data so now I have the following data :

data have;
input name $4. count ;
datalines;
john 100
Harr 90
Rick 80
Gini 70
kell 70
Rini 67
Holl 65
Radd 65
lola 60
;

What I want as the output is the top 5 names with the corresponding counts and then for the 6th row I want everything left to be grouped together labelled as 'Othr' and their counts summed.

john 100

Harr 90
Rick 80
Gini 70
kell 70

Othr 257

How can I achieve this?

Thanks in advance 🙂

Re: Ranking Output and then grouping the remaining

novinosrin — Fri, 23 Nov 2018 18:36:47 GMT

data have;
input name $4. count ;
datalines;
john 100
Harr 90
Rick 80
Gini 70
kell 70
Rini 67
Holl 65
Radd 65
lola 60
;
data want;
set have end=lr;
if _n_>5 then s+count;
if lr then do;
count=s;
name='other';
end;
if lr or _n_<=5 then output;
drop s;
run;

Re: Ranking Output and then grouping the remaining

new_sas_user_4 — Fri, 23 Nov 2018 20:16:48 GMT

Thanks a lot @novinosrin!!