https://communities.sas.com/t5/SAS-Procedures/Reg-Excel-and-Scheduling/m-p/69673#M20032 To identify the incoming file(s), you can use the FILENAME <FILEREF> PIPE (engine) to identifying files for processing. <BR /> <BR /> WIth this information you an execute a SAS macro using a SAS DATA step to read / import your Excel document with the LIBNAME <LIBREF> EXCEL command. <BR /> <BR /> The new, incoming data can be combined with your "All data daily" file using PROC APPEND.<BR /> <BR /> And, lastly, you can use the CALL SYSTEM command to move the file to another folder.<BR /> <BR /> I suggest you search the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website using these keywords - you will find SAS-hosted documentation and supplemental technical and conference topic-related reference material for your reference and use with examples.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.</LIBREF></FILEREF> Mon, 07 Sep 2009 11:49:45 GMT sbb 2009-09-07T11:49:45Z https://communities.sas.com/t5/SAS-Procedures/Reg-Excel-and-Scheduling/m-p/69672#M20031 Hi<BR /> <BR /> i will get data daily in 'C:\Desktop\data' in the excel sheete.The data in excel sheets is to be appended to All data daily .And after the datain excel sheet is appended it sholud be move to another folder called 'C:\Desktop|BACKUP' and i dont know the excel sheet name that are coming daily it should be kept sheduling daily the entire process.<BR /> Can any one help me Mon, 07 Sep 2009 05:58:17 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Excel-and-Scheduling/m-p/69672#M20031 R_Win 2009-09-07T05:58:17Z https://communities.sas.com/t5/SAS-Procedures/Reg-Excel-and-Scheduling/m-p/69673#M20032 To identify the incoming file(s), you can use the FILENAME <FILEREF> PIPE (engine) to identifying files for processing. <BR /> <BR /> WIth this information you an execute a SAS macro using a SAS DATA step to read / import your Excel document with the LIBNAME <LIBREF> EXCEL command. <BR /> <BR /> The new, incoming data can be combined with your "All data daily" file using PROC APPEND.<BR /> <BR /> And, lastly, you can use the CALL SYSTEM command to move the file to another folder.<BR /> <BR /> I suggest you search the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website using these keywords - you will find SAS-hosted documentation and supplemental technical and conference topic-related reference material for your reference and use with examples.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.</LIBREF></FILEREF> Mon, 07 Sep 2009 11:49:45 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Excel-and-Scheduling/m-p/69673#M20032 sbb 2009-09-07T11:49:45Z