https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513123#M2490 <P>I have data set that I am currently exporting into an excel sheet. Moving forward, I would like to continue to export into that same sheet without deleting the data currently in that sheet.</P><P>&nbsp;</P><P>The reason I would like to do this is because I am currently running the data for a large timeframe which causes the program to run for an extended period of time. If i was to shorten the timeframe to the latest month, and simply add the latest months data into the existing sheet, this would make things go much faster.</P><P>&nbsp;</P><P>Is there a way to do that within my program? Thank you for your help.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 Nov 2018 20:10:59 GMT aperansi 2018-11-27T20:10:59Z https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513123#M2490 <P>I have data set that I am currently exporting into an excel sheet. Moving forward, I would like to continue to export into that same sheet without deleting the data currently in that sheet.</P><P>&nbsp;</P><P>The reason I would like to do this is because I am currently running the data for a large timeframe which causes the program to run for an extended period of time. If i was to shorten the timeframe to the latest month, and simply add the latest months data into the existing sheet, this would make things go much faster.</P><P>&nbsp;</P><P>Is there a way to do that within my program? Thank you for your help.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 Nov 2018 20:10:59 GMT https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513123#M2490 aperansi 2018-11-27T20:10:59Z https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513168#M2493 Not easily I'm afraid. It's easier to redo the full workbook IMO. I actually can't even think of any way at the moment. Thu, 15 Nov 2018 00:48:42 GMT https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513168#M2493 Reeza 2018-11-15T00:48:42Z https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513329#M2511 Can you tell me what you mean by redo the full workbook? What are some ideas you have? Im not sure how I would really go about this. Thu, 15 Nov 2018 14:33:41 GMT https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513329#M2511 aperansi 2018-11-15T14:33:41Z https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513348#M2513 Pretty much what you’re doing now. Any incremental load would use a different tool, DDE or VBS in my experience and then you increase the chance of issues. Thu, 15 Nov 2018 15:04:22 GMT https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513348#M2513 Reeza 2018-11-15T15:04:22Z https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513950#M2614 Thank you Reeza Fri, 16 Nov 2018 16:11:22 GMT https://communities.sas.com/t5/New-SAS-User/Exporting-a-data-set-into-an-excel-sheet-without-deleting-the/m-p/513950#M2614 aperansi 2018-11-16T16:11:22Z