topic Re: TOP 10 Records in a group in SAS Programming

TOP 10 Records in a group

aarathi — Fri, 03 Jun 2016 10:43:34 GMT

Can any explain me how to filter top n rows in a particular group. for example for Each zone , top 10 locations need to be filtered.

Re: TOP 10 Records in a group

Kurt_Bremser — Fri, 03 Jun 2016 10:59:43 GMT

Sort by zone and the selection criteria (descending).

Then do;

data want;
set have;
by zone;
retain counter;
if first.zone
then counter = 1;
else counter + 1;
if counter le 10;
drop counter;
run;

Re: TOP 10 Records in a group

Jagadishkatam — Fri, 03 Jun 2016 12:05:07 GMT

Hi Aarathi,

Alternatively, you could try do loops as below, i took the example of shoes dataset. Hope this helps.

proc sort data=sashelp.shoes out=shoes;
by region descending stores ;
run;

data shoes_;
i=0;
do until(last.region);
set shoes;
by region descending stores ;
i+1;
if i <=10 then 
output;
end;
run;