SAS Quality Knowledge Base for Contact Information 27

Date (DMY)

Parse Definition

Date (DMY)
Description

The Date (DMY) parse definition parses dates with format DMY into a set of tokens.

Output Tokens Day
Month
Year
Example 1 Input Output Token Output
10/18/2007 Day 18
Month 10
Year 2007
Example 2 Input Output Token Output
10/1/07 Day 10
Month 1
Year 07
Example 3 Input Output Token Output
Ottobre 5, 2007 Day 5
Month Ottobre
Year 2007
Remarks If it is not possible to determine whether information in the input is a day, month, or year, it will be determined by the assumed order of day, month, and year.