topic Re: How to reorder variables in SAS Procedures

How to reorder variables

ct_surg — Fri, 15 Aug 2014 14:14:10 GMT

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.

Re: How to reorder variables

stat_sas — Fri, 15 Aug 2014 14:21:37 GMT

data want;

retain a b c x y z;

set have;

run;

Re: How to reorder variables

ct_surg — Fri, 15 Aug 2014 14:26:19 GMT

Perfect, thank you.

Re: How to reorder variables

Ksharp — Sat, 16 Aug 2014 12:42:40 GMT

proc sql;

create table want as

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

quit;

Xia Keshan

Re: How to reorder variables

ct_surg — Mon, 08 Sep 2014 22:37:57 GMT

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

Re: How to reorder variables

stat_sas — Tue, 09 Sep 2014 13:54:15 GMT

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;

Re: How to reorder variables

ct_surg — Sun, 14 Sep 2014 18:59:56 GMT

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

Re: How to reorder variables

ct_surg — Sun, 14 Sep 2014 19:01:40 GMT

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