topic Re: Sort all datasets in a library in SAS Programming

Sort all datasets in a library

BrahmanandaRao — Thu, 18 Mar 2021 04:36:09 GMT

How to sort all datasets in a library using macros

Re: Sort all datasets in a library

SASKiwi — Thu, 18 Mar 2021 05:19:01 GMT

Sorting requires a data order. What data order do you want?

Re: Sort all datasets in a library

andreas_lds — Thu, 18 Mar 2021 05:56:53 GMT

Do you want to sort all datasets using the same BY-statement?

Re: Sort all datasets in a library

BrahmanandaRao — Thu, 18 Mar 2021 07:47:53 GMT

Yes

Re: Sort all datasets in a library

japelin — Thu, 18 Mar 2021 08:06:49 GMT

how about this code

%Macro MALLSORT(lib=,sortvar=);
  data _null_;
    set sashelp.vstable;
    where libname=upcase("&lib");
    call symputx(cats('ds',_N_),memname);
    call symputx('nobs',_N_);
  run;
  %do i=1 %to &nobs;
    proc sort data=&&ds&i;
      by &sortvar;
    run;
  %end;
%Mend;

Re: Sort all datasets in a library

Kurt_Bremser — Thu, 18 Mar 2021 08:34:20 GMT

No macro needed, only macro variables:

data _null_;
set sashelp.vtable;
where libname = upcase("&lib.");
call execute("
  proc sort data=&lib.." !! strip(memname) !! ";
  by &sortvar.;
  run;
");
run;

Re: Sort all datasets in a library

BrahmanandaRao — Thu, 15 Jul 2021 09:43:47 GMT

How to call macro from above code

suppose I have datasets in a library like

data ds1;
set sashelp.class;
run;

data ds2;
set sashelp.cars;
run;

data ds3;
set sashelp.air;
run;

Re: Sort all datasets in a library

Kurt_Bremser — Thu, 15 Jul 2021 10:07:29 GMT

And what would be the common variable(s) to sort by?

Re: Sort all datasets in a library

BrahmanandaRao — Thu, 15 Jul 2021 10:15:58 GMT

No common variable for those datasets

class

cars

air

Re: Sort all datasets in a library

andreas_lds — Thu, 15 Jul 2021 10:18:59 GMT

@BrahmanandaRao wrote:

No common variable for those datasets

class

cars

air

Don't use a macro at all, but proc sort directly. Will improve readability of the code as bonus effect.

Re: Sort all datasets in a library

Kurt_Bremser — Thu, 15 Jul 2021 10:27:43 GMT

Then you are obviously in the wrong thread, because you answered @andreas_lds 's question:

Do you want to sort all datasets using the same BY-statement?

with

Yes

so your new question doesn't belong here.