Date

SAS Quality Knowledge Base for Contact Information 27

Date

Match Definition

Date
Description	The Date match definition generates match codes which can be used to cluster records containing date information.
Max Length of Match Code	15 characters
Example 1 Sensitivities 85-100	Input	Cluster ID
	２００１／３／１４	1
	2001年3月14日	1
	3/14/2001	1
	14-mar-01	1
	H13.3.14	1
	平成十三年三月十四日	1
	2001/3/14	1
	平成元年六月三十日	2
	昭和64年六月三十日	2
	2001/12/14	3
	2001/12/15	4
Remarks	All digits of the year, month, and day are evaluated. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 2 Sensitivities 80-84	Input	Cluster ID
	2001/12/14	1
	2001/12/15	1
	2001/12/24	2
Remarks	All digits of the year and month are evaluated. Only one digit of the day is evaluated. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 3 Sensitivities 75-79	Input	Cluster ID
	2001/12/15	1
	2001/12/24	1
	2001/11/14	2
Remarks	All digits of the year and month are evaluated. The day is ignored. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 4 Sensitivities 70-74	Input	Cluster ID
	2001/12/24	1
	2001/11/14	1
	2001/9/14	2
Remarks	All digits of the year are evaluated. Only one digit of the month is evaluated. The day is ignored. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 5 Sensitivities 65-69	Input	Cluster ID
	2001/11/14	1
	2001/9/14	1
	2002/12/14	2
Remarks	All digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 6 Sensitivities 60-64	Input	Cluster ID
	2001/9/14	1
	2002/12/14	1
	2012/12/14	2
Remarks	Only the first three digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.
Example 7 Sensitivities 50-59	Input	Cluster ID
	2002/12/14	1
	2012/12/14	1
	1990/12/14	2
Remarks	Only the first two digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Kanji numerals and Arabic numerals match. Any separators (including Japanese characters) match. Names of months match the corresponding digits that represent those months. Japanese Nengo years and Western years match. When the day and year are ambiguous, it is assumed that the last number is the year. It is assumed that two-digit sequences in the range 00-29 represent years in the range 2000-2029. It is assumed that two-digit sequences in the range 30-99 represent the years 1930-1999. When a year belongs to two Japanese Nengo, these two Japanese Nengo years match.