Chapter Contents

Previous

Next

DATETIMEw.

Category:

Date and time

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.

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.  

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

Examples

input date_and_time datetime20.;

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

See Also

	Formats: DATEw. DATETIMEw.d TIMEw.d
	Function: DATETIME
	Informats: DATEw. TIMEw.
	System Option: YEARCUTOFF=

Chapter Contents

Previous

Next

Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.