https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507379#M136180 <P>INDEX is faster.</P> <P>PRXMATCH is more flexible.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">POS=prxmatch('/(TEXT?4|TEXT7|TEXT9)/',STRING);</CODE></PRE> Thu, 25 Oct 2018 02:19:53 GMT ChrisNZ 2018-10-25T02:19:53Z https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507369#M136170 I tried using prxmatch would it be easier to use index? I am looking for word text4, text 7, and text9.<BR />Sometimes they are misspell for example tex4<BR />The index works if its one and spelled correctly<BR />Data test;<BR />Set test;<BR />Text_position( varaible,"text4");<BR />Run;<BR />This works great i need to add the additional text7 and text9 Thu, 25 Oct 2018 01:04:18 GMT https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507369#M136170 Gil_ 2018-10-25T01:04:18Z https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507379#M136180 <P>INDEX is faster.</P> <P>PRXMATCH is more flexible.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">POS=prxmatch('/(TEXT?4|TEXT7|TEXT9)/',STRING);</CODE></PRE> Thu, 25 Oct 2018 02:19:53 GMT https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507379#M136180 ChrisNZ 2018-10-25T02:19:53Z https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507386#M136186 Fuzzy matching words is hard. You’ll also make mistakes, so decide if it’s worth the effort first. Thu, 25 Oct 2018 03:02:25 GMT https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507386#M136186 Reeza 2018-10-25T03:02:25Z https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507400#M136196 The output is 0 even though the words is there. What is ? In text4 Thu, 25 Oct 2018 04:34:06 GMT https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507400#M136196 Gil_ 2018-10-25T04:34:06Z https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507415#M136207 <P><EM>The output is 0 even though the words is there. What is ? In text4</EM></P> <P>&nbsp;</P> <P>Make the search case insensitive?</P> <P>Add <FONT face="courier new,courier">i</FONT> after the second slash in the regular expression.</P> Thu, 25 Oct 2018 07:31:24 GMT https://communities.sas.com/t5/SAS-Programming/Finding-4-words-in-a-free-form-comment/m-p/507415#M136207 ChrisNZ 2018-10-25T07:31:24Z