Informats

DATETIMEw. Informat

Reads datetime values in the form ddmmmyy hh:mm:ss.ss or ddmmmyyyy hh:mm:ss.ss.

Category:

Date and Time

Syntax
Syntax Description
Details
Comparisons
Examples
See Also

Syntax

DATETIMEw.

Syntax Description

w

specifies the width of the input field.

Default:	18
Range:	13-40

Details

The datetime values must be in the following form: ddmmmyy or ddmmmyyyy, followed by a blank or special character, followed by hh:mm:ss.ss (the time). In the date,

dd: is an integer from 01 through 31 that represents the day of the month.
mmm: is the first three letters of the month name.
yy or yyyy: is a two-digit or four-digit integer that represents the year.

In the time,

hh: is the number of hours ranging from 00 through 23.
mm: is the number of minutes ranging from 00 through 59.
ss.ss: is the number of seconds ranging from 00 through 59 with the fraction of a second following the decimal point.

DATETIMEw. requires values for both the date and the time. However, the ss.ss portion is optional.

Note: SAS interprets a two-digit year as belonging to the 100-year span that is defined by the YEARCUTOFF= system option. [cautionend]

Note: SAS can read time values with AM and PM in them. [cautionend]

Comparisons

The DATETIMEw.d informat reads datetime values with optional separators in the form dd-mmm-yy<yy> hh:mm:ss.ss AM|PM, and the date and time can be separated by a special character.

The MDYAMPMw.d in format reads datetime values with optional separators in the form mm-dd-yy<yy> hh:mm:ss.ss AM | PM, and requires a space between the date and the time.

The YMDDTTMw.d informat reads datetime values with required separators in the form <yy>yy-mm-dd/hh:mm:ss.ss.

Examples

input date_and_time datetime20.;

Data Line	Results
----+----1----+----2
16mar08:11:23:07.4	1521285787.4
16mar2008/11:23:07.4	1521285787.4
16mar2008/11:23 PM	1521328980