https://communities.sas.com/t5/SAS-Data-Science/SAS-approximate-string-matching-fuzzy-search/m-p/75502#M470 I would create a 2x(100x200) data set with proc sql, and run the complev function, and output the max value by group.<BR /> <BR /> Russ Fri, 16 Apr 2010 13:22:17 GMT RussAlbright 2010-04-16T13:22:17Z https://communities.sas.com/t5/SAS-Data-Science/SAS-approximate-string-matching-fuzzy-search/m-p/75501#M469 Hi,<BR /> <BR /> I have two text files A.txt &amp; B.txt<BR /> <BR /> A.txt has 100 observations<BR /> B.txt has 200 observations<BR /> <BR /> For every observation in A, I need it to look through every observation in B and return the closest match based on the complev function.<BR /> <BR /> Is there a simple way to do this? Fri, 16 Apr 2010 08:15:42 GMT https://communities.sas.com/t5/SAS-Data-Science/SAS-approximate-string-matching-fuzzy-search/m-p/75501#M469 deleted_user 2010-04-16T08:15:42Z https://communities.sas.com/t5/SAS-Data-Science/SAS-approximate-string-matching-fuzzy-search/m-p/75502#M470 I would create a 2x(100x200) data set with proc sql, and run the complev function, and output the max value by group.<BR /> <BR /> Russ Fri, 16 Apr 2010 13:22:17 GMT https://communities.sas.com/t5/SAS-Data-Science/SAS-approximate-string-matching-fuzzy-search/m-p/75502#M470 RussAlbright 2010-04-16T13:22:17Z