Hi all,   I am trying to use a hashtable  to output the data from a loop up data set in a given set when the find() method finds a match, and in another set otherwise.   The problem is that when there is no match, the output I get contains the data in the hashtable corresponding to the previous observations for which there was a match. Hence the find() method.    Here is the code:   data matchAdmin nonmatchAdmin ;        if 0 then set master_Eir nobs=Nb;       if Nb^=0 then             do;                 declare Hash masterHash (dataset:'master_Eir');                 masterHash.DefineKey ('master_eircode_checked');                 masterHash.DefineData(ALL:'YES');                 masterHash.DefineDone();                do k=1 to n;                     set admin_Eir point=k nobs=n;                     rc=masterHash.find(key:admin_eircode_checked);                     if rc=0 then do;                          matchFound=1;                          output matchAdmin;                      end;                     else do;                        matchFound=0;                       output nonmatchAdmin;                    end;         end; end; run;   Thanks for your help,   Thierry ... View more

Dear all,   I am trying to use the use the find() function in SAS Enterprise 5.1.    It does not work as specified in all the literature I found on the web. It is only able to find perfect matches between two strings. For instance, it return 1 on find(col1,col2) when col1 contains "CORK" and col2 "CORK", but 0 when col1 contains "ICORK" and col2 contains "CORK".   Can someone explain why find() has the behavior ?   Thanks, Thierry   ... View more