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
04/07/02 04 07 2002
04July05 04 07 2005
04.07.05 04 07 2005
04July2005 04 07 2005
04-07-2005 04 07 2005
Remarks If the input year is a two-digit value, it is assumed to be within the hundred year span with 2019 as the end of the span. For example, a year of 19 will be 2019, but a year of 20 will be 1920.