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>
Organization: http://groups.google.com
Subject:      Re: How to do it?
Comments: To: sas-l@uga.edu
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
>
> news:42f7e5e5-07d8-4f21-8fff-c833fc5aabaa@i8g2000pro.googlegroups.com...
>
>
>
> > 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.