Hi,
This might help you out. Probably this is not the best solution but this might give you some idea on how to do it. Regarding scheduling, in what OS are you?
/* data set that contains the name of the datasets*/
proc sql;
create table temp as
select memname from dictionary.tables
where libname='Reports';
quit;
/* append to final table */
%macro append2final(dsn=);
proc append base=final data=&dsn force;run;
%mend append2final;
/* loop through the table containing table names of the library Reports */
data _null_;
set temp;
call execute('%append2final(dsn='|| memname ||')';
run;
Best Regards,
Milton