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.
data want;
retain a b c x y z;
set have;
run;
Perfect, thank you.
proc sql;
create table want as
select a,b,c,x,y,z from have;
quit;
Xia Keshan
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
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;
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.