My data set have variables VAR1, VAR2, and VAR3.
The variables are displayed in order VAR1, VAR3 and VAR2. I want them in order VAR1, VAR2 and VAR3.
How do I change the order in a DATA STEP?
data want;
retain var1 var2 var3;
set have;
run;
Often the order of variables does not matter, but I recently wrote an article about reordering variables according to a value of a statistic (mean, median, variance,...). Yes, I used the RETAIN statement. For details, see
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.