Ok, got the answer from SAS tech support. I need to remove the sheet_interval="none" option. Although this worked with ExcelXP tagset, with ODS Excel, this option is telling SAS to put everything on one tab. I could manually force a new tab with a sheet_interval="now" option; however this is the default behavior, so if I just avoid the sheet_interval="none" statement, it does the trick. So the code should look like this ods excel
file = "blah.xlsx"
options(
sheet_name ='Tab1Name'
)
;
{proc report here}
ods excel
options(
sheet_name ='Tab2Name'
)
;
{another proc report here}
etc.
... View more