Exact text match using Find

[krishmar1]

Hi,

I need to find an exact match of a text.

From the list below, I need to flag records (1 & 2) with the text "Connect". But when I use Find() it flags all the 4 records. Findw() is not helping either.

Connect

Service, Connect

Service, Connect/Boat

Service, Connect/Friend

Thanks!

[Haikuo · Accepted solution]

Findw should work for you in this case, you just need to specify the delimiters, otherwise the default will kick in, which includes '/' that you don't want.

data test;

     infile cards truncover;

     input str $ 20.;

     flag=findw(str,'Connect', ' ,')>0;

     cards;

Connect

Service, Connect

Service, Connect/Boat

Service, Connect/Friend

;

[krishmar1]

Thank you!