SAS Quality Knowledge Base for Contact Information 27

Date (YMD)

Standardization Definition

Date (YMD)
Description The Date (YMD) standardization definition standardizes dates that have format YMD. The output is a four-digit year, followed by a zero-padded two-digit month, followed by a zero-padded two-digit day. The year, month, and day are separated by spaces.
Examples Input Output
12gen10 2012 01 10
12/01/10 2012 01 10
30gen10 1930 01 10
30.10.10 1930 10 10
2015 gennaio 10 2015 01 10
2015-01-10 2015 01 10
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.