topic Appending/Set datasets issue in SAS Procedures

Appending/Set datasets issue

chirumalla — Fri, 25 Apr 2014 02:24:33 GMT

Hi monthly I will receive weekly datasets like XYZ_WK1, XYZ_WK2. few months I will receive 4 and few months 5. when I use SET/APPEND to Append data to Base table when one file is missed showing error message how to over come irrespective of datasets number need to append all data sets which are available.

data SOURCE.XYZ ;

set TARGET.XYZ_wk1

TARGET.XYZ_wk2

TARGET.XYZ_wk3

TARGET.XYZ_wk4

TARGET.XYZ_wk5

;

run;

proc append base=SOURCE.XYZ data=TARGET.XYZ_wk1;

run;

proc append base=SOURCE.XYZ data=TARGET.XYZ_wk2;

run;

proc append base=SOURCE.XYZ data=TARGET.XYZ_wk3;

run;

proc append base=SOURCE.XYZ data=TARGET.XYZ_wk4;

run;

Re: Appending/Set datasets issue

art297 — Fri, 25 Apr 2014 02:41:35 GMT

Here is one way:

proc sql noprint;

select catx('.',libname,memname)

into :files separated by ' '

from dictionary.tables

where libname="TARGET" and

memname like "XYZ%"

;

quit;

data target.xyz;

set &files.;

run;

Re: Appending/Set datasets issue

Tom — Fri, 25 Apr 2014 12:57:09 GMT

I think your list of dataset names will need to include the libname.

select catx('.',libname,memname) ....

Re: Appending/Set datasets issue

Tom — Fri, 25 Apr 2014 12:59:27 GMT

If your names all start with the same prefix then you could use a wildcard in the SET statement. (Note your LIBREF names seems backwards to me so I have reversed them in my example code below).

data target.xyz ;

set source.xyz_wk: ;

run;

Re: Appending/Set datasets issue

art297 — Fri, 25 Apr 2014 13:10:24 GMT

Tom,

You are absolutely correct, me bad, and I corrected my original post based on your post. As for the wild card, I didn't suggest it as (as I recall) that was only made available as of 9.3

Art