As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Fuzzy Match/Merge without a Common Key using SAS

From sasCommunity
Jump to: navigation, search


This article briefly describes a sample application where the normal SAS merge or SQL join would fail to provide the kind of results needed or hoped for. By using a set of SAS functions, custom programs and macros, and simple scoring techniques and common sense, the author developed a working model that matches two unlinked files that contain no common keys. The fuzzy matching process developed entailed over 1500 hours of development, testing, and revisions after being applied to several different projects and assignments.

Online Materials

View the pdf for this Observations article.

Contact Info

Please check out my user page.