The SAS Output Delivery System and reporting techniques

Sorting by 2nd column

Reply
New Contributor
Posts: 4

Sorting by 2nd column

How can I instruct SAS to sort a dataset by a certain column number regrdless of its name?

Thanks

Avirt

PROC Star
Posts: 7,486

Re: Sorting by 2nd column

You can do that easily with proc sql.  e.g.:

proc sql;

  create table want as

    select *

      from sashelp.class

        order by 2

  ;

quit;

Super Contributor
Posts: 1,636

Re: Sorting by 2nd column

example:

data have;
input (a b c d)(:$2.);
cards;
aa xx cc dd
ab cd ef gr
;
proc sql noprint;
  select name into :vars separated by ' ' from
    dictionary.columns
   where libname='WORK' and memname='HAVE';
quit;

%let i=2;
%let sort=%scan(&vars,&i);
proc sort data=have;
by &sort;
proc print;run;

Ask a Question
Discussion stats
  • 2 replies
  • 221 views
  • 6 likes
  • 3 in conversation