Sort all datasets in a library

[BrahmanandaRao]

How to sort all datasets in a library using macros

[SASKiwi]

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

[andreas_lds]

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

[BrahmanandaRao]

Yes

[japelin]

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;

[Kurt_Bremser]

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;

[BrahmanandaRao]

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;

[Kurt_Bremser]

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

[BrahmanandaRao]

No common variable for those datasets

class

cars

air

[andreas_lds]

---

@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.

[Kurt_Bremser]

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.