The SAS Output Delivery System and reporting techniques

Tableeditor - Autofilter function

Reply
N/A
Posts: 0

Tableeditor - Autofilter function

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.
N/A
Posts: 0

Re: Tableeditor - Autofilter function

Posted in reply to deleted_user
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.
SAS Employee
Posts: 88

Re: Tableeditor - Autofilter function

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 2 replies
  • 177 views
  • 0 likes
  • 2 in conversation