In a much earlier post I recommended creating a row index variable such
as ROWNUM in a Data step view using the automatic _N_ variable.
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of Pardee, Roy
Sent: Wednesday, March 12, 2008 12:33 PM
To: Howard Schreier <hs AT dc-sug DOT org>; SAS-***@LISTSERV.UGA.EDU
Subject: RE: Re: How to Proc SQL select top N records?
Yeah, this won't work in SAS. Our correspondent here may be used to
working with oracle, which adds that 'pseudocolumn' automatically (tho
even on oracle I think doing top N is a tad bit more complicated).
From: SAS(r) Discussion [mailto:SAS-***@LISTSERV.UGA.EDU] On Behalf Of
Howard Schreier <hs AT dc-sug DOT org>
Sent: Tuesday, March 11, 2008 6:54 PM
Subject: Re: How to Proc SQL select top N records?
I think that more or less begs the question. How do you derive the