Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

VA 7.1 Advanced Text Filter for all Cases (upper, lower, mixed)

Reply
Occasional Contributor
Posts: 15

VA 7.1 Advanced Text Filter for all Cases (upper, lower, mixed)

Is there a way to set up an advanced text filter that would return all text cases for a particular word without having to enter all the alternatives.

For example: <text category> does not contain "dog" (any case)  - this should exclude all text for dog DOG Dog or DOg. Is there an operator that can do this?

Thanks,

Howard

Esteemed Advisor
Posts: 7,293

Re: Advanced Text Filter for all Cases (upper, lower, mixed)

A number of functions (e.g., find and the regex functions) contain a modifier that ignores case.

Didn't realize that you asked this in regard to VA. Couldn't you edit the sql expression to apply the UPCASE function to the variable name?

Occasional Contributor
Posts: 15

Re: Advanced Text Filter for all Cases (upper, lower, mixed)

Yes thanks, this is for VA 7.1. So your saying import all sql text as upcase? I'd prefer to just deal with however the data appears on the SQL side as in some cases there may be a distinct difference and I'd rather not set an ETL import rule like that.  I'd like to just use a single function in my filter that will ignore case. As it is, I am entering multiple word filters to cover the most common case formats.

Esteemed Advisor
Posts: 7,293

Re: Advanced Text Filter for all Cases (upper, lower, mixed)

No, but I've never used VA. However, according to the documentation: 4 (Optional) You can click the Functions tab and select the functions to use with filtering.

I think that you only need to use the function UPCASE.

Occasional Contributor
Posts: 15

Re: Advanced Text Filter for all Cases (upper, lower, mixed)

Thanks. I'll check it out, though I'm not sure it's the solution.

Contributor
Posts: 23

Re: VA 7.1 Advanced Text Filter for all Cases (upper, lower, mixed)

You can set up an advanced filter to do this kind of operation.  I have used something similar (i believe) to allow users to use a smart search function.  Set up a parameter and then link this to an input box.  Drive the advanced filter from this imput box (the parameter).  In the advanced filter you can the add 'upcase' of whatever you need.

This is a screenshot of what I think you need to explore:

Magazine Combined_2015-03-04_16-44-30.png

Occasional Contributor
Posts: 15

Re: VA 7.1 Advanced Text Filter for all Cases (upper, lower, mixed)


Thanks Max. I'll check it out. Where would the input box appear? Is it just in the Adv Filter screen or does it appear somewhere in the Exploration right window?

New Contributor
Posts: 4

Re: VA 7.1 Advanced Text Filter for all Cases (upper, lower, mixed)

Actually a very good solution, thank you.

Ask a Question
Discussion stats
  • 7 replies
  • 578 views
  • 6 likes
  • 4 in conversation