Date: Thu, 22 May 2003 13:53:01 -0400
Reply-To: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Chakravarthy, Venky" <Venky.Chakravarthy@PFIZER.COM>
Subject: Re: _N_ in PROC SQL
Content-Type: text/plain; charset="iso-8859-1"
You can use the undocumented monotonic() function to simulate _n_.
proc sql ;
select monotonic() as rownum, *
from <your data> ;
If you are doing any GROUP BY processing in your SQL this may not work.
A better alternative is to use a datastep view.
data yourview / view = yourview ;
set yourdata ;
rownum = _n_ ;
From: Jeff Morison [mailto:jmt_mtf@YAHOO.COM]
Sent: Thursday, May 22, 2003 1:29 PM
Subject: _N_ in PROC SQL
Thanks to all who responded to my earlier qn.
Here is another one.
I need to create a variable with the value of _N_ in
PROC SQL?, is there a way to do this?.
It gives me this ERROR message
ERROR: The following columns were not found in the
contributing tables: _N_.
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.