topic Re: Tableeditor - Autofilter function in ODS and Base Reporting

Tableeditor - Autofilter function

deleted_user — Mon, 23 Jul 2007 16:43:08 GMT

To Chevell Parker/SAS experts.

Hi all, I'm trying to get the Autofilter to function correctly with this tagset. I'm using a single dataset that I'm outputting to HTML with the autofilter feature. The filter drop-down boxes appear on the output but are totally empty. No data from the dataset show so I can't filter.

Does anyone have an idea of what I'm missing here? I'm not too savvy with HTML and the SAS log does not give any clues as to what is happening.

Here's my code.

ODS LISTING CLOSE;
ODS TAGSETS.TABLEEDITOR
FILE="C:\DESKTOP\JUMPSTART\JUMP.HTML"
OPTIONS (AUTOFILTER="YES"
FILTER_COLS="1,2,3,4,5,6,7,8,9,10")
STYLE=STYLES.MYSTYLE;

PROC PRINT DATA=JUMP.JUMPDUMP;
RUN;

ODS TAGSETS.TABLEEDITOR CLOSE;

Any direction would be appreciated.

Thanks Ken.

Re: Tableeditor - Autofilter function

deleted_user — Mon, 23 Jul 2007 20:08:16 GMT

Hi All, okay so I did some checking with my HTML source against Chevell's autofilter example and I found this line missing from my HTML.

{
this.buildFilter(col, "(all)");
}

I put this line in my HTML and now the data shows and filters correctly. Does anyone know what Option command activates this code/feature using this tagset in SAS?
I've tried them all and in differing order but still can't get the data to show in the filters.

Thanks Ken.

Re: Tableeditor - Autofilter function

Chevell_sas — Tue, 24 Jul 2007 13:28:16 GMT

Hello Ken,

This should work as you have it, however, with this version I made a change which caused this problem which you have found. I have corrected this in the updated tagset plus added quite a few new features. I am updating the web site with the tagset ASAP and will be glad to email you the updated version. You can send me email at the below address:

Chevell.Parker@sas.com