Date:         Wed, 8 Nov 2006 10:40:52 -0600
Reply-To:     Yu Zhang <zhangyu05@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yu Zhang <zhangyu05@GMAIL.COM>
Subject:      Re: reordering columns
In-Reply-To:  <1163003922.721955.298730@i42g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

SELECT B,C,A,D FROM DATASET;

On 11/8/06, oercim <oercim@yahoo.com> wrote:
>
>         Let say I have a table with column names a,b,c,d  in  this
> order.  Using PROC SQL statements , how can i reorder the columns let
> say as an exmple b,c,a,d. Thanks  alot.
>