SAS Quality Knowledge Base for Contact Information 27
Phone | ||
---|---|---|
Description | The Phone match definition generates match codes which can be used to cluster records containing phone numbers. | |
Max Length of Match Code | 22 characters | |
Example 1 (Sensitivities 95-100) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 4 | |
3456789 | 5 | |
3456780 | 6 | |
34567891 | 7 | |
34567890 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 10 | |
Remarks | First three digits of the country code are evaluated. All digits of the area code are evaluated. All seven characters of a 7-digit base number are evaluated. All eight characters of an 8-digit base number are evaluated. First four characters of the extension are evaluated. | |
Example 2 (Sensitivities 90-95) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 4 | |
3456789 | 5 | |
3456780 | 6 | |
34567891 | 7 | |
34567890 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 9 | |
Remarks | First three digits of the country code are evaluated. All digits of the area code are evaluated. All seven digits of a 7-digit base number are evaluated. All eight digits of an 8-digit base number are evaluated. First two digits of the extension are evaluated. | |
Example 3 (Sensitivities 85-89) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 4 | |
3456789 | 5 | |
3456780 | 5 | |
3456700 | 6 | |
34567891 | 7 | |
34567890 | 7 | |
34567800 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 9 | |
Remarks | First three digits of the country code are evaluated. All digits of the area code are evaluated. First six digits of a 7-digit base number are evaluated. First seven digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 4 (Sensitivities 80-84) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 4 | |
3456789 | 5 | |
3456780 | 5 | |
3456700 | 6 | |
34567891 | 7 | |
34567890 | 7 | |
34567800 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 9 | |
Remarks | First two digits of the country code are evaluated. All digits of the area code are evaluated. First six digits of a 7-digit base number are evaluated. First seven digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 5 (Sensitivities 75-79) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 4 | |
3456789 | 5 | |
3456780 | 5 | |
3456700 | 6 | |
34567891 | 7 | |
34567890 | 7 | |
34567800 | 7 | |
34567000 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 9 | |
Remarks | First two digits of the country code are evaluated. All digits of the area code are evaluated. First six digits of a 7-digit base number are evaluated. First six digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 6 (Sensitivities 70-74) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 2 | |
593 6784569 | 3 | |
594 6784569 | 3 | |
580 6784569 | 4 | |
3456789 | 5 | |
3456780 | 5 | |
3456700 | 5 | |
3456000 | 6 | |
34567891 | 7 | |
34567890 | 7 | |
34567800 | 7 | |
34567000 | 8 | |
4473000 ext 12345 | 9 | |
4473000 ext 12346 | 9 | |
4473000 ext 12356 | 9 | |
Remarks | First two digits of the country code are evaluated. First two digits of the area code are evaluated. First five digits of a 7-digit base number are evaluated. First six digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 7 (Sensitivities 65-69) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 1 | |
593 6784569 | 2 | |
594 6784569 | 2 | |
580 6784569 | 2 | |
633 6784569 | 3 | |
3456789 | 4 | |
3456780 | 4 | |
3456700 | 4 | |
3456000 | 4 | |
3450000 | 5 | |
34567891 | 6 | |
34567890 | 6 | |
34567800 | 6 | |
34567000 | 6 | |
34560000 | 7 | |
4473000 ext 12345 | 8 | |
4473000 ext 12346 | 8 | |
4473000 ext 12356 | 8 | |
Remarks | Country code is not evaluated. First digit of the area code is evaluated. First four digits of a 7-digit base number are evaluated. First five digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 8 (Sensitivities 60-64) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 1 | |
593 6784569 | 2 | |
594 6784569 | 2 | |
580 6784569 | 2 | |
633 6784569 | 2 | |
3456789 | 3 | |
3456780 | 3 | |
3456700 | 3 | |
3456000 | 3 | |
3450000 | 5 | |
34567891 | 6 | |
34567890 | 6 | |
34567800 | 6 | |
34567000 | 6 | |
34560000 | 6 | |
34500000 | 7 | |
4473000 ext 12345 | 8 | |
4473000 ext 12346 | 8 | |
4473000 ext 12356 | 8 | |
Remarks | Country code is not evaluated. Area code is not evaluated. First four digits of a 7-digit base number are evaluated. First four digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 9 (Sensitivities 55-59) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 1 | |
593 6784569 | 2 | |
594 6784569 | 2 | |
580 6784569 | 2 | |
633 6784569 | 2 | |
3456789 | 3 | |
3456780 | 3 | |
3456700 | 3 | |
3456000 | 3 | |
3450000 | 3 | |
3400000 | 5 | |
34567891 | 6 | |
34567890 | 6 | |
34567800 | 6 | |
34567000 | 6 | |
34560000 | 6 | |
34500000 | 6 | |
34000000 | 7 | |
4473000 ext 12345 | 8 | |
4473000 ext 12346 | 8 | |
4473000 ext 12356 | 8 | |
Remarks | Country code is not evaluated. Area code is not evaluated. First three digits of a 7-digit base number are evaluated. First three digits of an 8-digit base number are evaluated. Extension is not evaluated. | |
Example 10 (Sensitivities 50-54) |
Input | Cluster ID |
+682 356648 | 1 | |
+683 356648 | 1 | |
+62 356648 | 1 | |
593 6784569 | 2 | |
594 6784569 | 2 | |
580 6784569 | 2 | |
633 6784569 | 2 | |
3456789 | 3 | |
3456780 | 3 | |
3456700 | 3 | |
3456000 | 3 | |
3450000 | 3 | |
3400000 | 3 | |
3000000 | 5 | |
34567891 | 6 | |
34567890 | 6 | |
34567800 | 6 | |
34567000 | 6 | |
34560000 | 6 | |
34500000 | 6 | |
34000000 | 6 | |
30000000 | 7 | |
4473000 ext 12345 | 8 | |
4473000 ext 12346 | 8 | |
4473000 ext 12356 | 8 | |
Remarks | Country code is not evaluated. Area code is not evaluated. First two digits of a 7-digit base number are evaluated. First two digits of an 8-digit base number are evaluated. Extension is not evaluated. |
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_ZHCHN_Match_Phone.html |