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 (June 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 18 Jun 2007 13:49:24 -0700
Reply-To:     "Pardee, Roy" <pardee.r@GHC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Pardee, Roy" <pardee.r@GHC.ORG>
Subject:      Re: Is there _N_ in SQL?
In-Reply-To:  A<0C094BFB78FEBC42B1BF98C83F49DB849629@TEEXB0VD.prod.travp.net>
Content-Type: text/plain; charset="us-ascii"

This dstep code doesn't take account of groups either, does it? Can you step us back a bit & say what you're trying to do, and why you care whether it's done in dstep or SQL?

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Wang,Jue Sent: Monday, June 18, 2007 1:14 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Is there _N_ in SQL?

I am wondering if there any equivalent statement in SQL that does the following:

Proc sort data=a; by x y; Run;

Data a; Set a; N=_N_; Run;

monotonic() doesn't gives the correct N within each group

Thanks

======================================================================= ====== This communication, together with any attachments hereto or links contained herein, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments hereto or links herein, from your system.

======================================================================= ====== The Travelers e-mail system made this annotation on 06/18/07, 16:13:37.


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