SAS Quality Knowledge Base for Contact Information 27

Phone

Match Definition

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
Examples Input Cluster ID
456-7891 0
456-7890 0
456-7800 1
2567-8912 2
2567-8910 2
2567-8900 3
+20 48 123 4567 4
048 123 4567 4
Work: 048 123 4567 4
048 123 4567 العمل 4
(047) 438 5396 5
4385396 كفر الشيخ 5
2545 7930 6
(02) 2545 7930 6
Remarks

Note Note: The results listed above reflect the default match sensitivity (85).

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.

Note that the number of digits retained in the match codes is a function of the number of digits in the base number and the match sensitivity. Governorates match their corresponding numeric area codes. Eight-digit (Cairo) base numbers match whether the 02 area code is present or not.