https://communities.sas.com/t5/SAS-Procedures/Reg-Appending/m-p/71365#M20602 Hi,<BR /> <BR /> 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?<BR /> <BR /> /* data set that contains the name of the datasets*/<BR /> proc sql;<BR /> create table temp as<BR /> select memname from dictionary.tables<BR /> where libname='Reports';<BR /> quit;<BR /> <BR /> /* append to final table */<BR /> %macro append2final(dsn=);<BR /> proc append base=final data=&amp;dsn force;run;<BR /> %mend append2final;<BR /> <BR /> /* loop through the table containing table names of the library Reports */<BR /> data _null_;<BR /> set temp;<BR /> call execute('%append2final(dsn='|| memname ||')';<BR /> run;<BR /> <BR /> Best Regards,<BR /> Milton Tue, 15 Sep 2009 11:36:01 GMT milts 2009-09-15T11:36:01Z https://communities.sas.com/t5/SAS-Procedures/Reg-Appending/m-p/71364#M20601 Hi<BR /> <BR /> 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. Tue, 15 Sep 2009 11:24:27 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Appending/m-p/71364#M20601 deleted_user 2009-09-15T11:24:27Z https://communities.sas.com/t5/SAS-Procedures/Reg-Appending/m-p/71365#M20602 Hi,<BR /> <BR /> 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?<BR /> <BR /> /* data set that contains the name of the datasets*/<BR /> proc sql;<BR /> create table temp as<BR /> select memname from dictionary.tables<BR /> where libname='Reports';<BR /> quit;<BR /> <BR /> /* append to final table */<BR /> %macro append2final(dsn=);<BR /> proc append base=final data=&amp;dsn force;run;<BR /> %mend append2final;<BR /> <BR /> /* loop through the table containing table names of the library Reports */<BR /> data _null_;<BR /> set temp;<BR /> call execute('%append2final(dsn='|| memname ||')';<BR /> run;<BR /> <BR /> Best Regards,<BR /> Milton Tue, 15 Sep 2009 11:36:01 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Appending/m-p/71365#M20602 milts 2009-09-15T11:36:01Z