SAS Quality Knowledge Base for Contact Information 27

Date (MDY)

Standardization Definition

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