topic Re: How to sort variables in alphabetical order as Output data in SAS EG? in SAS Enterprise Guide

How to sort variables in alphabetical order as Output data in SAS EG?

KubiK888 — Tue, 15 Aug 2017 16:34:38 GMT

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?

data WORK.DATA5;
set WORK.DATA4;
run;

Re: How to sort variables in alphabetical order as Output data in SAS EG?

WarrenKuhfeld — Tue, 15 Aug 2017 17:28:40 GMT

http://support.sas.com/kb/24/696.html

Re: How to sort variables in alphabetical order as Output data in SAS EG?

Reeza — Tue, 15 Aug 2017 17:29:09 GMT

@WarrenKuhfeld just a quick note that I edited your link to remove an extra space at the end.

Re: How to sort variables in alphabetical order as Output data in SAS EG?

Kurt_Bremser — Wed, 16 Aug 2017 06:33:17 GMT

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.