Date:         Thu, 1 Oct 2009 08:58:13 -0700
Reply-To:     demin <qdmiris@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         demin <qdmiris@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How to add a column with order(1,2,3...) like obs in print?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Oct 1, 11:20 am, demin <qdmi...@gmail.com> wrote:
> On Oct 1, 10:44 am, snoopy...@GMAIL.COM (Joe Matise) wrote:
>
>
>
>
>
> > Are you in a data step or PROC SQL?  In a data step, _N_ will (often) give
> > you the row number, or more precisely the number of iterations through the
> > data step loop.  So:
> > data test;
> > set sashelp.class;
> > obsnum=_n_;
> > run;
>
> > works, as long as you don't futz with other loops around the set statement.
>
> > In PROC SQL, unofficially, monotonic() gives you the row number, though it's
> > not guaranteed to work and is suggested not to use in production code.
>
> > If you need to order by the column you posted, then extract the numeric
> > portion at the end.  Something like
> > ORDER BY INPUT(SUBSTR(var,7),BEST12.)
> > will work, in the given example.  Like so:
>
> > data test;
> > input id $;
> > datalines;
> > Q12P3R1
> > Q12P3R10
> > Q12P3R2
> > Q12P3R3
> > ;;;;
> > run;
>
> > proc sql;
> > select * from test order by input(substr(id,7),BEST12.);
> > quit;
>
> > If your id variable is not so easy to parse [or needs ordering by other
> > parts] you may need to do something more complex, in that case you should
> > post to the list a more accurately detailed list of potential IDs.
>
> > -Joe
>
> > On Thu, Oct 1, 2009 at 9:24 AM, demin <qdmi...@gmail.com> wrote:
> > > Because I did something and made the order of my table has been
> > > changed, so I would like to add a order column to keep the old order.
> > > How to add such column with order 1,2,3...?
>
> > > Actually the column is character type, like :
> > > Q12P3R1
> > > Q12P3R10   ? shis should be placed on the last one, but
> > > Q12P3R2
> > > Q12P3R3
> > > ...
> > > ?Q12P3R10  should be placed on the last one, but by "proc sql select
> > > *... order by ..." till cannot get the order I want. how to solve
> > > this? thanks.- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks,
> for the method in PROC SQL as you said, it won't work when the column
> is more conplecated like:
> Q12P3R1
> Q12P3R10
> Q12P3R2
> Q12P3R3
> Q12P4R1
> Q12P5R1
> ... but now I learn this may use in other place.
>
> About the method in Data step, I am trying. Thanks.- Hide quoted text -
>
> - Show quoted text -

Yes, I agree that to use the already member, and I was trying the same
method when u sending the second reply, thanks a lot.
BTW, the discussions always update later than gmail, so sometimes not
sure should reply to gmail or the discussions.