Reg:Appending

[deleted_user]

Hi

i am having a dataset named Final. i am having a library named Reports,after the scheduling is completed there will be 5 datasets in that libarary(Reports).And i dont know the names of that datasets and they should be appended to final dataset .and it should be scheduled daily.

[milts]

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