SAS Quality Knowledge Base for Contact Information 27
| 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 |
| 10/01/12 | 10 01 2012 | |
| 10gen30 | 10 01 1930 | |
| 10.01.05 | 10 01 2005 | |
| 10 gen 2015 | 10 01 2015 | |
| 10-01-2015 | 10 01 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. | |
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_IT_Std_Date-DMY.html |