LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Behold this:

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

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


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 > > >

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.

Back to: Top of message | Previous page | Main SAS-L page