SAS Quality Knowledge Base for Contact Information 27

Date (MDY)

Parse Definition

Date (MDY)
Description The Date (MDY) parse definition parses dates with format MDY 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 1
Month 10
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 month, day, and year.