BookmarkSubscribeRSS Feed
JohnC_Munoz
Calcite | Level 5

I'm generating some html content with SAS' ods tagset.tableeditor. My date filter looks like this.

dumbfilter.PNG

It shows all values. I want the date filter to be more Excel-like and be knowledgeable about the content of what it's showing. When there's a date or numeric value, I want to give my users the option of selecting a range, or before, or after, etc, like this:date smart_filter.PNG

Thanks!

1 REPLY 1
Cynthia_sas
Diamond | Level 26

Hi:

  You posted a similar question earlier on autofilter in another track. Did you open a track with Tech Support or look at the Doc="Help" explanation for what you can do with autofilters? Since TAGSETS.TABLEEDITOR uses embedded JavaScript for some of how it works, you might be able to change the JavaScript that is written to make the Excel file. But again, that is really a question for Tech Support.

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1176 views
  • 0 likes
  • 2 in conversation