SAS Quality Knowledge Base for Contact Information 27
| 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 | |
| 2009年10月21日 | 1 | |
| 2009/10/21 | 1 | |
| 10/21/2009 | 1 | |
| 21-Oct-09 | 1 | |
| 二零零九年十月二十一日 | 1 | |
| 2009/10/22 | 2 | |
| 2009/10/23 | 3 | |
| Remarks | All digits of the year, month, and day are evaluated. Full-width and half-with characters match. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) match. Names of months match the corresponding digits that represent those months. 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. | |
| Example 2 (Sensitivities 80-84) |
Input | Cluster ID |
| 2009/10/21 | 1 | |
| 2009/10/22 | 1 | |
| 2009/10/12 | 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. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) match. Names of months match the corresponding digits that represent those months. 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. | |
| Example 3 (Sensitivities 75-79) |
Input | Cluster ID |
| 2009/10/15 | 1 | |
| 2009/10/22 | 1 | |
| 2009/11/12 | 2 | |
| Remarks | All digits of the year and month are evaluated. The day is ignored. Full-width and half-with characters match. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) match. Names of months match the corresponding digits that represent those months. 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. | |
| Example 4 (Sensitivities 70-74) |
Input | Cluster ID |
| 2009/10/15 | 1 | |
| 2009/11/22 | 1 | |
| 2009/09/12 | 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. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) match. Names of months match the corresponding digits that represent those months. 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. | |
| Example 5 (Sensitivities 65-69) |
Input | Cluster ID |
| 2009/10/15 | 1 | |
| 2009/11/22 | 1 | |
| 2008/09/12 | 2 | |
| Remarks | All digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) 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. | |
| Example 6 (Sensitivities 60-64) |
Input | Cluster ID |
| 2009/10/15 | 1 | |
| 2008/11/22 | 1 | |
| 2012/09/12 | 2 | |
| Remarks | Only the first 3 digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) match. Names of months match the corresponding digits that represent those months. 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. | |
| Example 7 (Sensitivities 50-59) |
Input | Cluster ID |
| 2009/10/15 | 1 | |
| 2012/11/22 | 1 | |
| 1990/09/12 | 2 | |
| Remarks | Only the first 2 digits of the year are evaluated. The month and day are ignored. Full-width and half-with characters match. Chinese numerals and Arabic numerals match. Any separators (including Chinese characters) 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. | |
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_ZHCHN_Match_Date.html |