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 26 characters
Examples Input Cluster ID
9902BW Dokkumer Nije Silen 0
9902SB Dokkumer Nieuwe Zijlen 0
8732EK Kubaard 1
8732 EM Kûbaard 1
8732EK Kübaard 1
1502RE EGMOND AD HOEF 2
1502RE EGMOND AAN DE HOEF 2
1502RE Egmond Binnen 2
1502RE EGMOND AAN ZEE 2
1000 AB AMSTERDAM 3
1000 AC AMSTERDAM 3
1000BA AMSTERDAM ZO 3
1000 CC AMSTERDAM ZUIDOOST 3
NL-1142JN 4
Postcode: 1142 JN 4
1142.JN 4
NL1142JN 4
Remarks

Note Note: The results listed above reflect the default match sensitivity (85).
On most sensitivities both the postal code and the city name contribute to the match code. You can combine match codes for these fields more freely if you parse the data and use the separate City and Postal Code definitions.

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: QKBCI_NLNLD_Match_CSPPC.html