scan function for multple words

[BonnaryW]

Hello,

I am looking for multple words within title.  I am not able to get this work. Please if you can help

data A;

input title $1-39;

datalines;

A TALE OF TWO CITIES

GENERAL MANAGER IN ONE CITY

MANAGER IS IN ANOTHER CITY

MANAGER IS NOT IN THE CITY

run;

data work;

set A;

WORD=FIND(title,("IS IN","IS NOT","i"); /**** "i" is to handle the case insensitive ****/

run;

[collinelliot · Accepted solution]

Maybe a regular expression?

word = prxmatch('/is in|is not/i', title);

[BonnaryW]

Thank you so much, it's work !!!

[PaigeMiller]

I'm pretty sure you can only search for one string using FIND. What you want is something like

FIND(title,"IS IN","i") or FIND(title,"IS NOT","i") 

[BonnaryW]

Thank you so much. It's work !!!

[ballardw]

If you have many of these combinations to search for it may be better to create a data set with the target string and then use SQL to find the matches.

data work.find;
   infile datalines truncover;
   input find $10.;
datalines;
Is in
is not
in one
;
run;

data work.A;
   input title $1-39;
datalines;
A TALE OF TWO CITIES
GENERAL MANAGER IN ONE CITY
MANAGER IS IN ANOTHER CITY
MANAGER IS NOT IN THE CITY
run;

proc sql;
   create table matched as
   select a.*, b.find, find(a.title,strip(b.find),'i') as word
   from work.a as a, work.find as b;
quit;

[BonnaryW]

Hello,
Thank you for replying with solution to my problem, I've accepted this answer as a solution.

word = prxmatch('/is in|is not/i', title);