Chapter 9:  Fuzzy Matching Programming

Introduction. 313

Data Sets Used in Examples. 314

6-Step Fuzzy Matching Process. 316

Determine Matching Variables. 317

Understand Data Values Distribution. 318

Data Cleaning. 323

Data Transformations. 326

Exact Matching Process. 327

Fuzzy Matching Processing. 328

Summary. 342

 

Introduction

Data comes in all forms, shapes, sizes, and complexities. Stored in files and data sets, SAS users across industries know all too well that data can be, and often is, problematic and plagued with a variety of issues. When unique and reliable identifiers are available, users routinely are able to match records from two or more data sets using merge, join, and/or hash programming techniques without problem. But, when ...

Get PROC SQL, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.