Date:         Wed, 31 Jan 2001 11:56:12 -0500
Reply-To:     "Shilling, Brian [PRI]" <BShillin@PRIUS.JNJ.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Shilling, Brian [PRI]" <BShillin@PRIUS.JNJ.COM>
Subject:      Re: Change Column Position
Comments: To: CWF <wf_cheung@YAHOO.COM>
Content-Type: multipart/alternative;

A very easy way (but maybe not the most efficient) is to add a datastep with
a retain statement, as follows:


Data a;
  set a;
  retain a b c d e f g .......; (in the new order requested)
run;

Hope this helps!

Brian

> -----Original Message-----
> From: CWF [SMTP:wf_cheung@YAHOO.COM]
> Sent: Wednesday, January 31, 2001 11:14 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Change Column Position
>
> Hi Everybody,
>
> I would like to ask which SAS command can change the position of column
> within a dataset.
>
> e.g. Original: Variable Sequence A, B, C, D
>        After Change: Variable Sequence B, D, C, A
>
> Regards,
> CWF

[text/html]