Use of wildcards in SAS visual analytics report filter

[Archimedes15]

As far as I can tell, this should work: ( 'DSN'n NotContains 'DSNDBPG.DSNDBD.GRP_____.OSMLATS.I0001.A0' )

I am trying to exclude all datasets like DSNDBPG.DSNDBD.GRP0%*.OSMLATS.*

I've tried:

DSNDBPG.DSNDBD.GRP0%.OSMLATS.%

DSNDBPG.DSNDBD.%.OSMLATS.I000.A0

DSNDBPG.DSNDBD.GRP%.OSMLATS.I000.%

I feel like this is a simple statement, but I cannot get it to function. If I enter a full DSname, it DOES exclude, so the DSN NotContains logic work, just not for wildcards.

Any help would be appreciated.

[RickStyll_SAS · Accepted solution]

SAS Visual Analytics does not support the use of wildcard characters when building filter expressions. To get the result you are looking for, you can use an AND in your expression to combine two text operators. Something like...

Here's what the text expression might look.

You can enter an idea to enhance SAS Visual Analytics to add support for wildcard characters when building filter expressions.

I hope this is helpful.

Rick Styll