The AUTOFILTER suboption might not work correctly in the ODS Tagsets.ExcelXP destination


If you write the REPORT procedure output to multiple worksheets in the Tagsets.ExcelXP destination and you use the AUTOFILTER suboption with each worksheet, the placement of the autofilters might be incorrect in the subsequent worksheets.

If the first PROC REPORT contains a compute block, the autofilters will be in the wrong row in the second PROC REPORT. The autofilters should be located in the header row, but they are incorrectly located in the body of the table.

Workaround

To work around this issue, use the ODS EXCEL destination rather than the Tagsets.ExcelXP destination.