Paper 86

Fuzzy Matching with SAS PROC SQL

September 24, 2025: 10:00 AM - 11:00 AM

Data Collection, Management, and Manipulation (DCMM), Executive Dining Room #3

Authors	Abstract
Mark Jordan	We must often join data from disparate data sources where matching by primary key is not possible. This paper addresses fuzzy matching techniques that can help get your data ready for analysis. In this presentation, I discuss and demonstrate usig PROC SQL to: - Standardize values for cleaner matches - Identify exact matches - Conduct fuzzy matching using traditional SAS functions, including:SOUNDEX()SPEDIS()COMPLEV()COMPGED() - Generate and use SAS Data Quality match codes

Mark Jordan

We must often join data from disparate data sources where matching by primary key is not possible. This paper addresses fuzzy matching techniques that can help get your data ready for analysis. In this presentation, I discuss and demonstrate usig PROC SQL to: - Standardize values for cleaner matches - Identify exact matches - Conduct fuzzy matching using traditional SAS functions, including:SOUNDEX()SPEDIS()COMPLEV()COMPGED() - Generate and use SAS Data Quality match codes