Hi:
I'm not sure what's going on. This works for me:
ods excel file='/folders/myfolders/all_output/test_filters.xlsx' options(autofilter='none' sheet_name='No filters'); proc print data=sashelp.class; run; ods excel options(autofilter='3-5' sheet_name='Filters on 3 4 5'); proc print data=sashelp.cars(obs=20); run; ods excel options(autofilter='all' sheet_name='filter all'); proc print data=sashelp.shoes(obs=20); run; ods excel close;
I get no filters in the first sheet, 3 columns with filters in the second sheet and all columns with filters in the 3rd sheet. The key is resetting the value for filters each time. As for the statement that the filters show up in row 6, that sort of makes sense because you have so many lines of ODS TEXT (not sure why you're using that instead of a TITLE statement with embedded_titles, but that's another issue). But as for WHY the ODS TEXT is impacting the filters on the subsequent sheets, that is a question for Tech Support.
Anyway, for help with WHERE the filter is going, with your specific code, you might want to work with Tech Support. If you have discovered a bug, that is something they need to investigate and report.
cynthia
... View more