Hello , I haven been creating excel reports (Excel 2003 XML spreadsheet type) in SAS using ODS TAGSET.EXCELXP code for years. My company just upgraded all its computer to office 2016. After upgrading to office 2016 I found out that I can no longer edit any of the excel reports that I create with SAS. Upon investigating with my system admin, I have found out that due to some policy they have decided to block editing/saving of all excel files prior to office 2007 and the policy cannot be changed. Which means I can open and view the files in protected view but can not do anything else. Upon hearing that, I have tried different options I have found on Google and SAS community sites. I have learned that using ODS EXCEL is an option but unfortunately for SAS 9.4 and onwards users. We just got base SAS 9.1 and sas EG 7.1 very recently. It is unlikely that my company would agree to upgrading to SAS 9.4 version any time soon. Therefore I am desperately seeking advice if anyone know how to create Excel 2007 and later workbook templates using base SAS 9.1 or SAS EG 7.1? So far I have tried the following and the all create reports in Excel 2003 format : ODS MSOFFICE2K FILE = *[produces in excel 2003 format] ODS EXCEL FILE = *[not supported in SAS 9.1 so gives me an error] ODS tagset.excelxp file =*[produces in excel 2003 format] Looking forward to your replies. Thank you, Chowdhury Anwar
... View more