Date:         Thu, 11 Apr 2002 17:46:41 -0400
Reply-To:     "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Subject:      Re: SQL and number of records
Comments: To: Action Man <wollo_desse@HOTMAIL.COM>
Content-Type: text/plain; charset=iso-8859-1

Wollo,

Behold this:

data a ;
   do x=1 to 5 ; output; end;
run ;

proc sql;
   select monotonic() as recnum from a ;
quit ;

Output:

  recnum
--------
       1
       2
       3
       4
       5

Kind regards,
=================
Paul M. Dorfman
Jacksonville, FL
=================

> -----Original Message-----
> From: Action Man [mailto:wollo_desse@HOTMAIL.COM]
> Sent: Thursday, April 11, 2002 4:59 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: SQL and number of records
>
>
> Hi Folks;
>
> I need to know number of records is a data set. I mean, we
> use _N_ in base
> SAS. Do we have such capability is SQL sas? I tried to use
> count, but count
> does not do the action I want. It count all records and gave
> me the total
> records per subject. Is the an _N_ function in SAS SQL?
>
> Kindly;
> Wollo
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp.
>
>


Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.