Date: Tue, 1 Sep 2009 11:09:27 -0700
Reply-To: JohnH <john.c.hennessey@SSA.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: JohnH <john.c.hennessey@SSA.GOV>
Subject: Re: How to do it?
Content-Type: text/plain; charset=ISO-8859-1
On Sep 1, 2:55 am, "Kenneth M. Lin" <kenm...@aol.com> wrote:
> The better question is why do you need to do it in PROC SQL?
> "Michael" <michae...@gmail.com> wrote in message
> > Hi,
> > I have the following
> > a b
> > 1 5
> > 2 8
> > 5 7
> > 8 9
> > I want to add a column to show the row number by using Proc SQL. Could
> > please anyone show me that? Thanks.- Hide quoted text -
> - Show quoted text -
Create a new column in SQL with the value, monotonic(). This will be
the row number.