|Date: ||Wed, 7 Oct 1998 20:07:08 -0400|
|Reply-To: ||Jules Bosch <jxb@BELLATLANTIC.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Jules Bosch <jxb@BELLATLANTIC.NET>|
|Organization: ||Bosch Systems Inc.|
|Subject: ||Re: Top Results Data Set|
|Content-Type: ||text/plain; charset=us-ascii|
Brenden Bertuola wrote:
> SS wrote in message <361ACEFA.firstname.lastname@example.org>...
> >I want to create a new data set with the top 25 sales people in each
> >I tried
> > If first.market then do;
> > a=_N_+24;
> > do until (_N_=a);
> > output;
> > end;
> > end;
> >What I got was the top performer in each market (only one per market).
> >Any help would be appreciated. Thank you.
> retain a;
> If first.market then a=25;
> if a>0 then output
This will take some research but I believe there is a statement, option,
or function in PROC TABULATE that will list top performers.