SAS Quality Knowledge Base for Contact Information 27

Social Security Number (Birth Date)

Standardization Definition

Social Security Number (Birth Date)
Description

The Social Security Number (Birth Date) standardization definition returns the birth date information in Social Security Numbers in YYMMDD format.

Examples Input Output
'BRNGTN68B05F915Q' 680205
BRN-GTN-73-C-57-A225-D 730317
BJOISA56P12A123B 560912
JORPAU45P62C123B 450922
Remarks This definition converts the single letter representing the month into a two-digit number. The definition also converts the two-digit number representing both day and gender into the correct day by subtracting 40 if the number is greater than 40. For example: 41 = 01, 57 = 17, 13 = 13.