I need to do a word search on a text field. While I know how to search for multiple words using the Prxmatch function, I am not sure how I can search words such as "fire suppression", "Young men", and etc, i.e., a simple phrase that has two words or more. If I were to split the phrase into two separate words, like "fire" and "suppression", then I will get many wrong matches due to the word "fire". The same is true for the words "Young" or "men". Is there a way to combine these words and use it in the Prxmatch function?
Thanks.
A nice example can be found at: https://support.google.com/a/answer/1371417?hl=en#Match-Word-or-Phrase-in-a-List
Art, CEO, AnalystFinder.com
With RegEx you're not really searching for words but for strings/text patterns. A blank between two words is nothing else than another character so simply search for such strings, i.e. '/fire suppression|young men/i'
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
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.
Ready to level-up your skills? Choose your own adventure.