BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10

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!

3 REPLIES 3
Reeza
Super User

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. 

DavePrinsloo
Pyrite | Level 9
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

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 13774 views
  • 0 likes
  • 4 in conversation