Note: To obtain optimal results, before performing data cleansing on phone numbers, the area code or governorate (which are often stored in databases separately from the base number) should first be concatenated with the base number.
SAS Quality Knowledge Base for Contact Information 27
| Phone (Legacy Mobile Conversion) | ||
|---|---|---|
| Description | The Phone (Legacy Mobile Conversion) standardization definition standardizes phone numbers for domestic use and converts legacy mobile codes to the current format. | |
| Examples | Input | Output |
| 012 555 5555 | 0122 555 5555 | |
| 018 555 5555 | 0128 555 5555 | |
| 017 555 5555 | 0127 555 5555 | |
| 0150 555 5555 | 0120 555 5555 | |
| 010 555 5555 | 0100 555 5555 | |
| 016 555 5555 | 0106 555 5555 | |
| 019 555 5555 | 0109 555 5555 | |
| 0151 555 5555 | 0101 555 5555 | |
| 011 555 5555 | 0111 555 5555 | |
| 014 555 5555 | 0114 555 5555 | |
| 0152 555 5555 | 0112 555 5555 | |
| +20 12 555 5555 | 0122 555 5555 | |
| +20 18 555 5555 | 0128 555 5555 | |
| +20 17 555 5555 | 0127 555 5555 | |
| +20 150 555 5555 | 0120 555 5555 | |
| +20 10 555 5555 | 0100 555 5555 | |
| +20 16 555 5555 | 0106 555 5555 | |
| +20 19 555 5555 | 0109 555 5555 | |
| +20 151 555 5555 | 0101 555 5555 | |
| +20 11 555 5555 | 0111 555 5555 | |
| +20 14 555 5555 | 0114 555 5555 | |
| +20 152 555 5555 | 0112 555 5555 | |
| Remarks |
|
|
| You can apply the Phone (Legacy Mobile Conversion) standardization definition prior to applying the Phone match definition if matching legacy numbers with their current format is desired. | ||
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_AREGY_Std_Phone-LegacyMobileConv.html |