https://communities.sas.com/t5/SAS-Programming/how-do-I-find-words-in-text-using-find/m-p/281573#M57127 <P>Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">find_hmbp=find(permit,facility_hmbp_3,'it')</CODE></PRE> <P>Hope this helps,</P> <P>- Jan.</P> Thu, 30 Jun 2016 21:33:57 GMT jklaverstijn 2016-06-30T21:33:57Z https://communities.sas.com/t5/SAS-Programming/how-do-I-find-words-in-text-using-find/m-p/281569#M57126 <P>permit is a text field with length 40.<BR />facility is a text field with length 60.<BR />facility_hmbp_3 = scan(facility,3,'') with length 40.</P><P>&nbsp;</P><P>If facility_hmbp_3 is equal to Lewis then the variable find_hmbp should be 6 for permit="OCEH Lewis Sub" where find_hmbp=find(permit,facility_hmbp_3,'i').<BR />However, I'm currently getting 0.<BR />If I change find_hmbp=find(permit,"Lewis",'i') then I do get 6.<BR />Why am I not getting 6 with find_hmbp=find(permit,facility_hmbp_3,'i')?</P><P>Thank you.</P> Thu, 30 Jun 2016 21:23:43 GMT https://communities.sas.com/t5/SAS-Programming/how-do-I-find-words-in-text-using-find/m-p/281569#M57126 gzr2mz39 2016-06-30T21:23:43Z https://communities.sas.com/t5/SAS-Programming/how-do-I-find-words-in-text-using-find/m-p/281573#M57127 <P>Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">find_hmbp=find(permit,facility_hmbp_3,'it')</CODE></PRE> <P>Hope this helps,</P> <P>- Jan.</P> Thu, 30 Jun 2016 21:33:57 GMT https://communities.sas.com/t5/SAS-Programming/how-do-I-find-words-in-text-using-find/m-p/281573#M57127 jklaverstijn 2016-06-30T21:33:57Z