Date:         Fri, 19 Mar 2010 17:36:05 -0700
Reply-To:     Patrick <patrick.matter@GMX.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrick <patrick.matter@GMX.CH>
Organization: http://groups.google.com
Subject:      Re: aggregate remaining obs /records SQL
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I guess what you could do is creating an additional variable for the
'group by' statement.

This variable should contain a distinct value for the top 3 rows and
an identical value for all other rows.

Search the forum with "top sql" - there are already quite a few
threads around identifying  "top" rows.

I would expect that you'll end up with a sub-select and a case
statement.

HTH
Patrick