https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781650#M249091 I am trying to export my SAS output to an existing excel sheet where I need the data on a particular sheet and cell. I don't want SAS to create or overwrite my excel file but to simply allocate the output to my worksheet. Any help will be greatly appreciated. Mon, 22 Nov 2021 04:07:05 GMT Tboat 2021-11-22T04:07:05Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781650#M249091 I am trying to export my SAS output to an existing excel sheet where I need the data on a particular sheet and cell. I don't want SAS to create or overwrite my excel file but to simply allocate the output to my worksheet. Any help will be greatly appreciated. Mon, 22 Nov 2021 04:07:05 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781650#M249091 Tboat 2021-11-22T04:07:05Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781649#M249095 I am trying to export my SAS output to an existing excel sheet where I need the data on a particular sheet and cell. I don't want SAS to create or overwrite my excel file but to simply allocate the output to my worksheet. Any help will be greatly appreciated. Mon, 22 Nov 2021 04:04:55 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781649#M249095 Tboat 2021-11-22T04:04:55Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781651#M249092 Did you try PROC EXPORT and specifying the range/cells? Mon, 22 Nov 2021 04:40:33 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781651#M249092 Reeza 2021-11-22T04:40:33Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781654#M249096 <P>Define a range in your Excel file where you want SAS to write, and use proc export.</P> Mon, 22 Nov 2021 05:20:59 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/781654#M249096 ChrisNZ 2021-11-22T05:20:59Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/782098#M249305 For some reason the Range statement is not supported with Proc export. Wed, 24 Nov 2021 00:38:24 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/782098#M249305 Tboat 2021-11-24T00:38:24Z https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/782115#M249313 Why do you say that? I'm almost certain it's valid for DBMS=XLSX.<BR /><BR />Can you show the code that was tried? If it generated an error, please include that as well. Wed, 24 Nov 2021 03:33:32 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-export-my-output-to-an-excel-sheet-without-overwriting/m-p/782115#M249313 Reeza 2021-11-24T03:33:32Z