BookmarkSubscribeRSS Feed
ChenB
Calcite | Level 5

Hello everyone,
I'm trying to filter files that have a good word and a word that changes its meaning does not appear before it.
I have a concept of good_words and a concept of changing_words and I want the system to find for me the good_words that do not appear before the changing_words
for example:
Today is a beautiful day - will appear
Today is not a good day - will not appear.
Do you have any suggestions for a solution?
Thank you!!

1 REPLY 1
Madelyn_SAS
SAS Super FREQ

Does it have to specifically be words in a certain position, or can you just come up with a list of words like "not" that could be filtered regardless of location?  If so, could you simply create a filter like: 

( 'Comment'n NotContains UpCase(not') )

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

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