How to reorder variables

[ct_surg]

Hello,

I am looking for a very easy way to custom order variables within a data set.  For example, I have a dataset with variables currently in order x a b y z c

And I would like to reorder them a b c x y z.

I have looked at a few methods (e.g., order=) but they all seem like circuitous methods. What is the easiest way?

Thank you in advance.

[stat_sas · Accepted solution]

data want;

   retain  a b c x y z;

  set have;

run;

[ct_surg]

Perfect, thank you.

[Ksharp]

proc sql;

create table want as

  select a,b,c,x,y,z  from have;

quit;

Xia Keshan

[ct_surg]

Within a single variable, is there a way to custom order the outputs in proc freq?

For example;

var1 = c a b

var2 = 1 2 3

proc freq data;

     tables var1*var2;

run;

display such that table outputs as

   1 2 3

a

b

c

[stat_sas]

If I understand it correctly you are looking for a cross tab like this

data have;
input var1 $ var2;
datalines;
a 1
b 2
c 3
;

proc freq data=have;
table var1*var2/nocol norow nopercent ;
run;

[ct_surg]

I would like to reorder variables within var1.  For example, var1 currently displays as

a  c   b   d

I would like it to display as

a   b   c   d

[ct_surg]

More precisely, and just focusing on var 1

proc freq data=;

     tables var1;

run;

currently:

a           c              b               d

1           4              5               7

desired:

a           b              c               d

1           5              4               7