SAS Quality Knowledge Base for Contact Information 27

Date (Western Calendar)

Standardization Definition

Date (Western Calendar)
Description The Date (Western Calendar) standardization definition standardizes date expressions to Western calendar format.
Examples Input Output Explanation
(2009/10/21) 2009/10/21 Standardize calendar identifier to YYYY/MM/DD format.
二零零九年十月二十一日 2009/10/21  
14-Mar-01 2001/03/14 Standardize month name. When the day and year are ambiguous, consider the last number to be the year.
2009/10/21 2009/10/21 Convert full-width to half-width.
20091021 2009/10/21 8 digits are considered to be YYYYMMDD format.
Remarks Supports dates from 1901 to 2050. Assumes two-digit years 00-29 are 2000-2029. Assumes two-digit years 30-99 are 1930-1999.