SAS Quality Knowledge Base for Contact Information 27

Date (DMY)

Standardization Definition

Date (DMY)
Description The Date (DMY) standardization definition standardizes dates that have format DMY. The output is a zero-padded two-digit day, followed by a zero-padded two-digit month, followed by a four-digit year. The day, month, and year are separated by spaces.
Examples Input Output
10/01/12 10 01 2012
10gen30 10 01 1930
10.01.05 10 01 2005
10 gen 2015 10 01 2015
10-01-2015 10 01 2015
Remarks If the input year is a two-digit value, it is assumed to be within the hundred year span with 2029 as the end of the span. For example, a year of 29 will be 2029, but a year of 30 will be 1930.