I'm trying to export a dataset to a macro activated Excel workbook Code below proc export dbms=Excelcs data=db_final outfile="\\My_computer\KPM\Output\KPM_DK_Business.xlsm" replace; SHEET='Data1'; server="My_server"; port=9621; run; The workbook already exist, and so does sheet "Data1". I want to overwrite the existing "Data1" with the new export using "replace". But SAS creates a new sheet called "Data11" where it outputs the dataset. How can I straighten this out? (SAS version 9.4 and exporting to Excel 2010) Appreciate all the help I can get! Best August
... View more