topic Re: Use of wildcards in SAS visual analytics report filter in New SAS User

Use of wildcards in SAS visual analytics report filter

Archimedes15 — Fri, 05 Oct 2018 17:02:52 GMT

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.

Re: Use of wildcards in SAS visual analytics report filter

RickStyll_SAS — Fri, 12 Oct 2018 15:20:57 GMT

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