@chprby12 wrote:
Hi,
I found out I can perform highlighting and also have multiple sheets in one workbook. I just have to revert to outputting to older Excel version, saving to an .xls file.
Thanks!
It depends on your version of SAS. If you have 9.4+ you can use ODS EXCEL and get a native XLSX file.
ODS HTML will produce an HTML file, even if you label it xls. Excel will open it (most of the time) but you will have a warning pop up.
... View more