I'm looking to reverse the order of all columns in a sas dataset. I believe the best way to do this would be to transpose the column data to be rows and then reorder the rows.
Here is my code:
*Step One;
data pre_transpose;
set sashelp.class;
*set &&dataset&i.. ;
_row_ + 1; * Unique identifier ;
length _charvar_ $20; * Create 1 character variable ;
run;
*Step Two --> Is this where I would reverse columns? ;
proc transpose data = pre_transpose out = middle (where = (lowcase(_name_) ne '_row_'));
by _row_;
var _all_;
quit;
Here are pictures of my output:
So, would I reverse the column order in the second step or is there a better way of achieving this result?
Do something like this
proc sql noprint;
select name into :vars separated by ' '
from dictionary.columns
where libname="SASHELP" and memname='CLASS'
order by varnum descending;
quit;
%put &vars.;
data want;
format &vars.;
set sashelp.class;
run;
I agree with @PeterClemmensen in principle, but suggest using retain rather than format. Using format, as such, you'd lose any formats that you had assigned. So, instead, I'd recommend using:
proc sql noprint; select name into :vars separated by ' ' from dictionary.columns where libname="SASHELP" and memname='CLASS' order by varnum descending; quit; data want; retain &vars.; set sashelp.class; run;
That way you don't risk losing anything,
Art, CEO, AnalystFinder.com
Show the code you submitted. The libname and memname have to be in upper case. Were they?
Art, CEO, AnalystFinder.com
Art. thank you for clarifying that the libname and memname statements have to be in upper case. This has resolved my issue!
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.