1. Sort dataset by group and variable of interest
2. Add a counter to count the values
3. Take top N as desired
*Assuming N = 5, take top 5 tallest students by sex;
*1 - sort by variables;
proc sort data=sashelp.class out=class;
by sex descending height;
run;
data want;
set class;
by sex;
*Create counter for each group;
if first.sex then count=1;
else count+1;
*Extract based on N;
if count<5;
run;
... View more