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
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]

Examples

input date_and_time datetime20.;

When the Data Line = ...	The Result is ...
----+----1----+----2
16mar97:11:23:07.4	1237202587.4
16mar1997/11:23:07.4	1237202587.4
16mar1997/11:23 PM	1237245780.0