SAS Quality Knowledge Base for Contact Information 27
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 | 36 characters | |
Example 1 (Sensitivities 95-100) |
Input | Cluster ID |
福建省泉州市丰田572000 | 1 | |
福建省泉州市丰泽572000 | 1 | |
福建省泉州市丰泽572001 | 2 | |
福建省泉州市丰泽572012 | 3 | |
Remarks | Province, City, and Postal Code are evaluated. | |
Example 2 (Sensitivities 90-94) |
Input | Cluster ID |
福建省泉州市丰泽572000 | 1 | |
福建省泉州市丰泽572001 | 1 | |
福建省泉州市丰泽572012 | 2 | |
福建省泉州市丰泽572123 | 3 | |
Remarks | Province, City, and the first 5 digits of Postal Code are evaluated. | |
Example 3 (Sensitivities 85-89) |
Input | Cluster ID |
福建省泉州市丰泽572001 | 1 | |
福建省泉州市丰泽572012 | 1 | |
福建省泉州市丰泽572123 | 2 | |
福建省泉州市丰泽573234 | 3 | |
Remarks | Province, City, and the first 4 digits of Postal Code are evaluated. | |
Example 4 (Sensitivities 80-84) |
Input | Cluster ID |
福建省泉州市丰泽572012 | 1 | |
福建省泉州市丰泽572123 | 1 | |
福建省泉州市丰泽573234 | 2 | |
福建省泉州市丰泽584345 | 3 | |
Remarks | Province, City, and the first 3 digits of Postal Code are evaluated. | |
Example 5 (Sensitivities 75-79) |
Input | Cluster ID |
福建省泉州市丰泽572123 | 1 | |
福建省泉州市丰泽573234 | 1 | |
福建省泉州市丰泽584345 | 2 | |
福建省泉州市丰泽FR-12345 | 3 | |
Remarks | Province, City, and the first 2 digits of Postal Code are evaluated. | |
Example 6 (Sensitivities 70-74) |
Input | Cluster ID |
福建省泉州市丰泽573234 | 1 | |
福建省泉州市丰泽584345 | 1 | |
福建省泉州市丰泽FR-12345 | 2 | |
福建省泉州市丰泽12345 | 2 | |
Remarks | Province, City, and the first digit of Postal Code is evaluated. | |
Example 7 (Sensitivities 65-69) |
Input | Cluster ID |
福建省泉州市丰泽012345 | 1 | |
福建省厦门市朝阳234567 | 2 | |
厦门市朝阳234567 | 3 | |
广东省深圳市福田345678 | 4 | |
Remarks | Only Province and City are evaluated. | |
Example 8 (Sensitivities 60-64) |
Input | Cluster ID |
福建省泉州市丰泽012345 | 1 | |
福建省厦门市朝阳234567 | 2 | |
厦门市朝阳234567 | 2 | |
广东省深圳市福田345678 | 3 | |
Remarks | Only City is evaluated. |
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_ZHCHN_Match_CSPPC.html |