SAS Quality Knowledge Base for Contact Information 27

City - State/Province - Postal Code

Match Definition

City - State/Province - Postal Code
Description The City - State/Province - Postal Code match definition generates match codes which can be used to cluster records containing last line address information.
Max Length of Match Code 46 characters
Examples Input Cluster ID
מזרח ירושלים 68087 0
מערב ירושלים 68087 0
ירושלים 68087 0
תל אביב, 67133 1
תל אביב, 67134 1
דאר צבאי 02229 צהל חיפה 2
דאר צבאי 2229 צהל חיפה 2
תל אביב, 67899 3
תל אביב יפו, 67899 3
תל-אביב-יפו, 67899 3
יפו, 67899 3
חצור אשדוד 6097100 4
חצור אשדוד 60971 4
Remarks Note Note: The results listed above reflect the default match sensitivity (85).

Regarding matching the existing 5-digit postal codes with the new 7-digit postal codes: at the default sensitivity, the last 2-digits of a 7-digit postal code are ignored (as seen in the last two examples). At sensitivity 90 and 95, 5-digit postal codes do not match 7-digit postal codes. For 7-digit postal codes: at sensitivity 90, the first 6-digits are considered. At sensitivity 95, all 7-digits are considered.