Original dataset:
Type Class ... Total ... Category
1. Need to move the column 'Total' to the end without changing the order for the rest of columns.
The result looks like:
Type Class ... Category Total
2. Need to move the column 'Total' to the beginning without changing the order for the rest of columns.
Total Type Class ... Category
Requirements:
Hard-coding like
retain ColA ColB ... ColZ Total;
wouldn't work because we wouldn't know the names for the rest of the columns or how many columns there are (they are dynamic).
Thank you.
Use the KEEP= and/or DROP= dataset options.
data one ;
set have (drop=Total);
set have ;
run;
data two;
set have (keep=Total);
set have ;
run;
Use the KEEP= and/or DROP= dataset options.
data one ;
set have (drop=Total);
set have ;
run;
data two;
set have (keep=Total);
set have ;
run;
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.