How can I instruct SAS to sort a dataset by a certain column number regrdless of its name?
Thanks
Avirt
You can do that easily with proc sql. e.g.:
proc sql;
create table want as
select *
from sashelp.class
order by 2
;
quit;
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.