SAS Quality Knowledge Base for Contact Information 27
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. |
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_CSCZE_Std_BirthNumber.html |