DATETIMEw.

DATETIMEw.

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- 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.;

Data Lines Results

----+----1----+----2

16mar97:11:23:07.4

1237202587.4

16mar1997/11:23:07.4

1237202587.4

16mar1997/11:23 PM

1237245780.0

See Also

Data Lines	Results
----+----1----+----2
16mar97:11:23:07.4	1237202587.4
16mar1997/11:23:07.4	1237202587.4
16mar1997/11:23 PM	1237245780.0

Formats:

DATEw.

DATETIMEw.d

TIMEw.d

Function:

DATETIME

Informats:

DATEw.

TIMEw.

System Option:

YEARCUTOFF=

Chapter Contents
Previous
Next
Top of Page