Merge all datasets in library

[SAShole]

I have 15 datasets in a library. the data is already sorted. is there a way to merge them all together with out having to write each one out?

Thanks!

[Linlin · Accepted solution]

data class1 class2 class3;
  set sashelp.class;
  run;

/*  if your datasets begin with same letters */
  data want;
   merge c:;
   by name;
  run;

/* begin with different letters */

proc sql noprint;
   select memname into : names
     from dictionary.tables
    where libname='WORK'; /* note: libname must be in upcase */
data want;
   merge &names;
   by name;
  run;

[SAShole]

Thanks Lin Lin!

this is just what i was looking for.

[SAShole]

the SQL method seems to merge class1 only.

[Linlin]

sorry. using the updated one:

proc sql noprint;

   select memname into : names separated by '  '

     from dictionary.tables

       where libname='WORK'; /* note: libname must be in upcase */

data want;

   merge &names;

   by name;

  run;

Linlin

[MikeZdeb]

hi ... just modify the code (without "SEPARATED BY" you only get one memname)  ...

proc sql noprint;

select memname into : names separated by ' '

from dictionary.tables

where libname='WORK'; /* note: libname must be in upcase */

quit;