topic Re: Merge all datasets in library in SAS Programming

Merge all datasets in library

SAShole — Fri, 27 Apr 2012 16:43:28 GMT

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!

Re: Merge all datasets in library

Linlin — Fri, 27 Apr 2012 17:08:46 GMT

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;

Re: Merge all datasets in library

SAShole — Fri, 27 Apr 2012 17:39:17 GMT

Thanks Lin Lin!

this is just what i was looking for.

Re: Merge all datasets in library

SAShole — Fri, 27 Apr 2012 17:52:25 GMT

the SQL method seems to merge class1 only.

Re: Merge all datasets in library

Linlin — Fri, 27 Apr 2012 18:05:30 GMT

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

Re: Merge all datasets in library

MikeZdeb — Fri, 27 Apr 2012 18:05:36 GMT

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;