Date:         Tue, 11 Mar 2008 15:04:01 -0400
Reply-To:     Steven Raimi <sraimi@MARKETINGASSOCIATES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Steven Raimi <sraimi@MARKETINGASSOCIATES.COM>
Subject:      Re: How to Proc SQL select top N records?

On Tue, 11 Mar 2008 11:40:29 -0700, Ruve <bandbig@GMAIL.COM> wrote:

>How to Proc SQL select top N records in SAS?
>
>Just like "Select Top 10" in SQL Server?  I just want to see the top
>10 results without having to saving all query results into a dataset.
>
>Thanks!


proc sql outobs=10;  /* limit to first 10 results */
   select groupvar, count(*)
   from table
   group by groupvar
   order by 2 desc; /* this is how you make them the TOP 10 */
run;


Steve Raimi