topic Re: scan function for multple words in SAS Programming

scan function for multple words

BonnaryW — Wed, 05 Apr 2017 16:35:58 GMT

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;

Re: scan function for multple words

collinelliot — Wed, 05 Apr 2017 16:56:48 GMT

Maybe a regular expression?

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

Re: scan function for multple words

PaigeMiller — Wed, 05 Apr 2017 16:57:41 GMT

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")

Re: scan function for multple words

BonnaryW — Wed, 05 Apr 2017 17:08:20 GMT

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

Re: scan function for multple words

BonnaryW — Wed, 05 Apr 2017 17:10:20 GMT

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

Re: scan function for multple words

ballardw — Wed, 05 Apr 2017 17:16:05 GMT

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;

Re: scan function for multple words

BonnaryW — Wed, 05 Apr 2017 17:19:20 GMT

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);