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
2001/3/14 2001/03/14 Standardize Fullwidth characters to Halfwidth.
2001年3月14日 2001/03/14 Standardize calendar identifier to YYYY/MM/DD format.
3/14/2001 2001/03/14 Consider 4-digit number as year.
14-mar-01 2001/03/14 Standardize month name to digit. When the day and year are ambiguous, consider the last number to be the year.
H13.3.14 2001/03/14 Convert Nengo year to western year.
平成13年3月14日 2001/03/14 Convert Nengo year to western year.
平成十三年三月十四日 2001/03/14 Standardize Kanji numbers.
平成元年三月十四日 1989/03/14  
Remarks This definition supports dates from 1901 (明治34年) to 2050 (平成62年). The definition assumes two-digit years 00-29 are 2000-2029. The definition assumes two-digit years 30-99 are 1930-1999.