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!
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
;
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
;
Thank you!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.