After the recent upgrade to SAS 9.4 M5 the following code does not produce an excel workbook with the output on separate sheets. Prior to the upgrade this worked fine. ods excel file= "outputfile.xlsx" options (sheet_name= "Screen Fails" sheet_interval= "none); proc report data= screenfails; ... run; ods excel options (sheet_name= "A5 Subjects" sheet_interval= "none"); proc report data= a5subjects; ... run; ods excel options (sheet_name= "A6 Subjects" sheet_interval= "none"); proc report data= a6subjects; ... run; ods excel close; Thank you for assisting me.
... View more