ANYDTDTEw. Informat

Reads and extracts the date value from various date, time, and datetime forms.

Category:

Date and Time

Syntax

ANYDTDTEw.

Syntax Description

w

specifies the width of the input field.

Default	9
Range	5–32

Details

The ANYDTDTE informat reads input data that corresponds to any of the following informats or date, time, or datetime forms and extracts the date part from the derived value.

Informat or Form of Input	Example Data	Informat or Form of Input	Example Data
DATE	01JAN12 01JAN2012	MONYY	JAN12 JAN2012
DATETIME	01JAN12 14:30:08 01JAN2012 14:30:08.5	TIME	14:30 14:30:08.05
DDMMYY	010112 01012012	YMDDTTM	12-01-01 11:23
JULIAN	12001 2012001	YYMMDD	120101 20120101
MDYAMPM	01-01-12 3:53 pm	YYQ	12Q1 2012Q1
MMDDYY	010112 01012012	YY<YY>xMM 1	12/01 2012-01
MMxYY<YY> 1	01/12 01-2012	month-day-year	January 1, 2012
1x is a special character that separates the month from the year.

If the input value is a time-only value, then SAS assumes a date of 01JAN1960.

It is possible for input data such as 01-02-03 or 01-02 to be ambiguous with respect to the month, day, and year. In this case, the DATESTYLE system option indicates the order of the month, day, and year.

Input data that contains colons is interpreted as time data. For example, 2013:12 is interpreted as 2013 hours and 12 minutes, not as the year 2013 and the month 12. The date result of reading a time value is zero.

Comparisons

The ANYDTDTE informat extracts the date part from the derived value. The ANYDTDTM informat extracts the datetime part. The ANYDTTME informat extracts the time part.

Example

input dateinfo anydtdte21.;

Data Line	Informat Form	Result	Formatted with the DATEw. Format
----+----1----+----2
01JAN12	DATE	18993	01JAN12
01JAN2012 14:30:08.5	DATETIME	18993	01JAN12
01012012	DDMMYY	18993	01JAN12
2012001	JULIAN	18993	01JAN12
01/01/12	MMDDYY	18993	01JAN12
JAN2012	MONYY	18993	01JAN12
14:30	TIME	0	01JAN60
20120101	YYMMDD	18993	01JAN12
12q1	YYQ	18993	01JAN12
January 1, 2012	none	18993	01JAN12

ANYDTDTEw. Informat

Syntax

Syntax Description

w

Details

Comparisons

Example

See Also