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.