SAS Quality Knowledge Base for Contact Information 27

Phone (with Governorate)

Standardization Definition

Phone (with Governorate)
Description The Phone (with Governorate) standardization definition standardizes phone numbers for domestic use and converts the numeric area code to the Arabic name of the governorate served by that area code.
Examples Input Output
+20 2 2999 9999 2999 9999 القاهرة الكبرى
02 2999 9999 2999 9999 القاهرة الكبرى
2999 9999 2999 9999 القاهرة الكبرى
03 499 9999 499 9999 الاسكندرية
084 499 9999 499 9999 الفيوم
Remarks

NoteNote: 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.

The Phone (with Governorate) standardization definition inserts the القاهرة الكبرى string onto eight-digit numbers, as shown in the third example.