topic Re: how to find multiple words in a string in SAS Procedures

how to find multiple words in a string

GeorgeSAS — Sun, 20 Mar 2016 01:20:18 GMT

Hello All,

How to find more than one words in a string?

I want find 'abc', 'sas','hi' in a string. I can use FINDW function three times:

if FINDW(string, 'sas') and FINDW(string, 'abc') and FINDW(tring, 'hi') then flag=1;

how to use a function only once to do this?

Thanks!

Re: how to find multiple words in a string

Haikuo — Sun, 20 Mar 2016 01:24:24 GMT

Prxmatch

Re: how to find multiple words in a string

Reeza — Sun, 20 Mar 2016 02:18:23 GMT

If you're doing text analytics I find it useful to split a sentence into components, switch to a long format - one word is a row, with a sentence identifier.

It makes it easier to do this type of analysis.

Re: how to find multiple words in a string

DavePrinsloo — Wed, 13 May 2020 17:47:49 GMT

The PRXMATCH function, for Perl Regular Expressions Match, can do it

if prxmatch("m/abc|sas|hi/oi",string) > 0 then flag=1;
else found=0;

see https://support.sas.com/kb/38/719.html