Hi, I'm having trouble to update an existing sheet in an Excel workbook. I'm using the following code: libname xls excel "file.xlsx" scan_text=no; proc datasets lib = xls nolist; delete 'ValueLevel$'n 'WhereClauses$'n; run; quit; data xls.'ValueLevel$'N(dblabel=yes); set to_vallev; run; data xls.'WhereClauses$'N(dblabel=yes); set to_whecla; run; libname xls clear; When using this code, the following error occurs: ERROR: The MS Excel table ValueLevel$ has been opened for OUTPUT. This table already exists, or there is a name conflict with an existing object. This table will not be replaced. This engine does not support the REPLACE option. ERROR: The MS Excel table WhereClauses$ has been opened for OUTPUT. This table already exists, or there is a name conflict with an existing object. This table will not be replaced. This engine does not support the REPLACE option. Is there anyone who has an idea on how to update the already existing Excel sheet? Regards, Tommy
... View more