topic Exact text match using Find in SAS Programming https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208507#M38767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to find an exact match of a text. </P><P>From the list below, I need to flag records (1 &amp; 2) with the text "Connect". But when I use Find() it flags all the 4 records. Findw() is not helping either.</P><P></P><P>Connect</P><P>Service, Connect</P><P>Service, Connect/Boat</P><P>Service, Connect/Friend</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 23 Mar 2015 23:57:51 GMT krishmar1 2015-03-23T23:57:51Z Exact text match using Find https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208507#M38767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to find an exact match of a text. </P><P>From the list below, I need to flag records (1 &amp; 2) with the text "Connect". But when I use Find() it flags all the 4 records. Findw() is not helping either.</P><P></P><P>Connect</P><P>Service, Connect</P><P>Service, Connect/Boat</P><P>Service, Connect/Friend</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 23 Mar 2015 23:57:51 GMT https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208507#M38767 krishmar1 2015-03-23T23:57:51Z Re: Exact text match using Find https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208508#M38768 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P style="margin-bottom: .0001pt;"><STRONG style="color: navy; background: white; font-family: 'Courier New';">data</STRONG><SPAN style="font-family: 'Courier New'; color: black; background: white;"> test;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; color: blue; background: white;">infile</SPAN> <SPAN style="font-family: 'Courier New'; color: blue; background: white;">cards</SPAN> <SPAN style="font-family: 'Courier New'; color: blue; background: white;">truncover</SPAN><SPAN style="font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; color: blue; background: white;">input</SPAN><SPAN style="font-family: 'Courier New'; color: black; background: white;"> str $ </SPAN><STRONG style="color: teal; background: white; font-family: 'Courier New';">20.</STRONG><SPAN style="font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-family: 'Courier New'; color: black; background: white;">&nbsp;&nbsp;&nbsp;&nbsp; flag=findw(str,</SPAN><SPAN style="font-family: 'Courier New'; color: purple; background: white;">'Connect'</SPAN><SPAN style="font-family: 'Courier New'; color: black; background: white;">, </SPAN><SPAN style="font-family: 'Courier New'; color: purple; background: white;">' ,'</SPAN><SPAN style="font-family: 'Courier New'; color: black; background: white;">)&gt;</SPAN><STRONG style="color: teal; background: white; font-family: 'Courier New';">0</STRONG><SPAN style="font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-family: 'Courier New'; color: blue; background: white;">cards</SPAN><SPAN style="font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-family: 'Courier New'; color: black; background: #FFFFC0;">Connect</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-family: 'Courier New'; color: black; background: #FFFFC0;">Service, Connect</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-family: 'Courier New'; color: black; background: #FFFFC0;">Service, Connect/Boat</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-family: 'Courier New'; color: black; background: #FFFFC0;">Service, Connect/Friend</SPAN></P><P><SPAN style="font-family: 'Courier New'; color: black; background: white;">;</SPAN></P></BODY></HTML> Tue, 24 Mar 2015 00:39:37 GMT https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208508#M38768 Haikuo 2015-03-24T00:39:37Z Re: Exact text match using Find https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208509#M38769 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 24 Mar 2015 04:52:46 GMT https://communities.sas.com/t5/SAS-Programming/Exact-text-match-using-Find/m-p/208509#M38769 krishmar1 2015-03-24T04:52:46Z