Date:         Sat, 5 Oct 1996 02:31:22 GMT
Reply-To:     Bernard Tremblay <bertrem@QUEBECTEL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Bernard Tremblay <bertrem@QUEBECTEL.COM>
Organization: Imaginasys enr
Subject:      Re: howto: delete/keep obs with 2 byvars

You have to count yourself the observations you output.
Change:
 
> PROC SORT;
>   BY X DESCENDING Y;
> IF FIRST.X THEN DO;
>   IF _N_>5 THEN DELETE;
> END;
> IF LAST.X THEN OUTPUT;
>
 
to:
> PROC SORT;
>   BY X DESCENDING Y;
run;
 
  data five;
   retain n 0;
   drop n;
   set _last_; by x descending y;
   if first.x then n=0;
   n+1;
  if n<5;
run;
 
And the trick is done.
 
                Good Luck!
 
                        Bernard Tremblay,
                        Imaginasys enr.
                        bertrem@quebectel.com