08-15-2017 12:34 PM
I have a table which the variables are in specific order as Output data, how can I sort it so they are presented in alphabetical order?
08-16-2017 02:33 AM
A quick way by retrieving the column names from dictionary.columns and using call execute:
%let inlib=sashelp; %let inset=class; %let outlib=work; %let outset=class; proc sql; create table vars as select name from dictionary.columns where libname = upcase("&inlib.") and memname = upcase("&inset.") order by name; quit; data _null_; set vars end=done; if _n_ = 1 then call execute("data &outlib..&outset.; format "); call execute(name !! ' '); if done then call execute("; set &inlib..&inset.; run;"); run;
You can easily wrap that into a macro with the four macrovars as macro parameters.