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
July04, 02 07 04 2002
07/04/02 07 04 2002
July04, 05 07 04 2005
07.04.05 07 04 2005
July 4, 2005 07 04 2005
07-04-2005 07 04 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.