There are two ODS DESTINATIONS that will allow you to set autofilters:
1) TAGSETS.TABLEEDITOR -- creates an HTML file that can be viewed in a browser or in Excel
2) TAGSETS.EXCELXP -- creates an Excel Spreadsheet Markup Language file with the ability to set AUTOFILTER to on -- so that when the file is opened in Excel, you will see the AUTOFILTERS (this file cannot be opened in a browser, only with Excel)
However, neither of these destinations is automatically available to you under the EG choices for output types. You can create SAS code in an EG code node to use either of these two ODS destinations (assuming 1) you have SAS 9 on your server and 2) both tagset definitions are available on the server -- you will have to download both of these tagset definitions and make sure they're on the server before you use them).
For more information about TAGSETS.TABLEEDITOR: http://www2.sas.com/proceedings/forum2008/258-2008.pdf -- contains code examples, such as this one:
ods tagsets.tableeditor file="filename.html"
proc print data=sashelp.class(obs=10);
title “Sort and filter columns”;
ods tagsets.tableeditor close;
Note: the above code will NOT work until you have installed the TableEditor tagset template definition on your SAS installation or server.
My next question: Now that I've got the autofilters to work on an HTML output with the EGDefault style, is it possible to get autofilters to work on a custom style? I'm trying to use my own style, and the autofilters are not populating. Any ideas?