What will happen when we export to excel with the same sheet name?

[imdickson]

Hi everyone. I am out of office now and cant do any testing with SAS. I have a question in my mind right now.

If i have a script that will write dataset into excel file that already exist in a folder.

For example:

My script will write dataset "CAR" to excel called cardata.xlsx with the sheetname "All Car"

What if cardata.xlsx already exist? Will the script prompt error saying sheetname "All Car" already exist and prompt error? or it will overwrite the entire xlsx fire?

[Cynthia_sas]

Hi:
The answer depends on what your "script" or program uses to do the "export" -- are you doing PROC EXPORT? Are you using the LIBNAME engine for EXCEL or XLSX? Are you using ODS EXCEL? How you are creating CARDATA.XLSX or writing to it makes a difference.

Cynthia