topic Variable Re-order in SAS Procedures

Variable Re-order

kuridisanjeev — Sat, 21 Jan 2012 16:59:11 GMT

i want to print the variable names based on alphabetical order..

can you suggest any one????

thanks..

art297 — Sat, 21 Jan 2012 17:11:03 GMT

Here is one way:

proc sql noprint;

select name

into :reorder

separated by ' '

from dictionary.columns

where libname="SASHELP" and

memname="CLASS"

order by name

;

quit;

proc print data=sashelp.class;

var &reorder.;

run;

kuridisanjeev — Sat, 21 Jan 2012 17:25:17 GMT

Thank you art297 for quick reply..

i found another way..

proc contents data=sashelp.class out=class1(keep=name);

run;

proc sql;

select name into:names separated by '' from class1;

quit;

data final;

retain &names;

set sashelp.class;

run;

art297 — Sat, 21 Jan 2012 17:52:03 GMT

I'm sure there are additional ways. I like the one I proposed as it requires less steps then the method you found.