Proc Append then Delete in a loop

[data_null__]

Since PROC APPEND is a statement in PROC DATASET I think you should at least nest the repeated APPENDs in PROC DATASETS.  If SAVE statement is not be appropiate you can just gen a DELETE for the list of APPEND data sets.

data D0912 D0913 D0914 D0915;
   set sashelp.class;
   run;
%let base=D0912;
proc sql noprint;
   select catx(' ','APPEND BASE=',"&base",'DATA=',memname,';') into :append
      from dictionary.members
      where libname eq 'WORK' and upcase(memname) ne %upcase("&base");
   quit;
   run;
proc datasets;
   &append;
   run;
   save &base;
   run;
   quit;

[Ksharp]

I think Art's code is good enough except for typing some more words. It is very fast way for large tabls.

Keep in mind that SAVE statement will only keep the &base , other tables will be deleted include other  needed tables, so you should be careful to use it.

Ksharp