Variable Re-order

[kuridisanjeev]

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

can you suggest any one????

thanks..

[art297 · Accepted solution]

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]

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]

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