How do I export my output to an excel sheet without overwriting the file.

[Tboat]

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.

[Tboat]

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.

[ChrisNZ · Accepted solution]

Define a range in your Excel file where you want SAS to write, and use proc export.

[Tboat]

For some reason the Range statement is not supported with Proc export.

[Reeza]

Why do you say that? I'm almost certain it's valid for DBMS=XLSX.

Can you show the code that was tried? If it generated an error, please include that as well.

[Reeza]

Did you try PROC EXPORT and specifying the range/cells?