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 |