When exporting to .xlsx I used the following code proc export data=MARKET outfile = "&path.\Market Report.xlsx" dbms=EXCELCS replace; sheet= "MARKET"; run; The export ran successfully. In the excel that SAS created, there are two sheets, SAS_empty_ and Market. I want the Market sheet, but the SAS_empty_ sheet is annoying and I don't want that. what can I do to stop SAS from creating this blank sheet.
... View more
