SAS Quality Knowledge Base for Contact Information 27

Birth Number

Standardization Definition

Birth Number
Description The Birth Number standardization definition standardizes birth numbers.
Examples Input Output
9312236076 931223/6076
530731456 530731/456
535731 - 456 535731/456
93-62-23/6147 936223/6147
Remarks This Birth Number standardization definition requires the input data to be in the form of YYMMDDOOO where YY is year of birth, MM is month of birth, DD is day of birth, and OOO is order number, which consists of three-digits if the birth year is before 1954 and four-digits if later than 1954. Month of birth values 01 through 12 are male and 51 through 62 are female.

The recommended procedure is to first determine if the input string is correctly formatted, then apply parsing to the correctly formatted input data only. To determine if the formatting is correct, do one of the following:

1. Parse the string using the Parse definition for Birth Number. Assign a Result Code Field in the Parse node in DataFlux Data Management Studio. Output with NO SOLUTION results is not formatted correctly and should be processed separately.

2. Run Gender Analysis on the input string using the Gender Analysis definition for Birth Number. Input strings that generate U (Unknown) results are not formatted correctly and should be processed separately.