SAS Quality Knowledge Base for Contact Information 27
| 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. | |
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_HE_Std_Date-MDY.html |