NetNews Usenet Archive 1993 #3/NN_1993_3.iso/spool/bit/listserv/sasl/5760

Internet Message Format | 1993-01-27 | 1.7 KB

Path: sparky!uunet!stanford.edu!bu.edu!olivea!spool.mu.edu!sdd.hp.com!zaphod.mps.ohio-state.edu!howland.reston.ans.net!paladin.american.edu!auvm!LOBBY.TI.COM!RSNYDER
From: [e-mail] (R. Snyder)
Newsgroups: bit.listserv.sas-l
Subject: Re: Reordering variables in a SAS dataset
Message-ID: <[e-mail]>
Date: 26 Jan 93 17:27:57 GMT
Sender: "SAS(r) Discussion" <[e-mail]>
Reply-To: "R. Snyder" <[e-mail]>
Lines: 41
Comments: Gated by [e-mail]
X-Mailer: ELM [version 2.2 PL16]
Comments: To: [e-mail]
Comments: cc: [e-mail]
In-Reply-To:  <[e-mail]>; from "Ted Greenstein" at Jan
              26, 93 10:22 am

SUBJECT:   Reordering data set variables
SUMMARY:   SQL
REL/PLTF:  6.08/Windows
E-ADDR:    [e-mail]
NAME:      Bob Snyder
COMPANY:   Texas Instruments, Sherman, TX
PHONE:     [phone]
FAX:       [phone]
>
> Is there an easy way to reorder the variables in a SAS dataset (this
> is under 6.08 for Windows)?  I know that I can (a) change the order
> in which the data are read from the raw data file initially, and (b)
> write the variables out using a PUT statement, then read them back in
> the desired order.  But isn't there some easier way?
>
<stuff deleted>
>
> Theodore N. Greenstein
> 307 1911 Building
> Department of Sociology and Anthropology
> North Carolina State University
> Raleigh, NC 27695-8107
>
> Voice: [phone]  FAX: [phone]
> Email: [e-mail]
>
Hi,

Since you are using 6.08 you can use PROC SQL to easily perform this task.

proc sql;

create TABLE | VIEW new as

  select var1, var2, ..., varN
    from old;

quit;

Regards,
Bob