Date:         Mon, 18 Jun 2007 16:13:36 -0400
Reply-To:     "Wang,Jue" <JWANG@TRAVELERS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Wang,Jue" <JWANG@TRAVELERS.COM>
Subject:      Re: Is there _N_ in SQL?
In-Reply-To:  <16FD64291482A34F995D2AF14A5C932C015A74AF@MAIL002.prod.ds.russell.com>
Content-Type: text/plain; charset=us-ascii

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.