E8601TZw.d Informat

Syntax Description

w

specifies the width of the input field.

Default:	14
Range:	9-20
Requirement:	To read a time with the Z time zone indicator, the width of the input field must be 9 if data follows on the same line of data.

d

(optional) specifies the number of digits to the right of the decimal point in the value for the lowest order component.

Default:	0
Range:	0-6

UTC time values specify a time and a time zone based on the zero meridian in Greenwich, England. The E8602TZ informat reads UTC time values that are specified in one of the following ISO 8601 extended notations:

The following list explains the UTC time variables:

hh

is a two-digit hour (zero padded), between 00 and 23

mm

is a two-digit minute (zero padded), between 00 and 59

ss

is a two-digit second (zero padded), between 00 and 59

.ffffff

are optional fractional seconds, with a precision of up to six digits, where each digit is between 0 - 9

Z

indicate zero meridian or UTC time

+|-hh:mm

is an hour and minute signed offset from zero meridian. Note that the offset must be +|-hh:mm (that is, + or - and five characters).

Use the + for time zones east of the zero meridian and use the - for time zones west of the zero meridian.

Restriction:

The shorter form +|-hh is not supported.

When SAS reads a UTC time by using the E8601TZ informat and the adjusted time is greater than 24:00:00 or less than 00:00:00, SAS adjusts the time so that it represents a time between 00:00:00 and 24:00:00. For example, if SAS reads the UTC time 23:43:44-05:00 using the E8601TZ informat, SAS adds 5 hours to the time so that the value is 28:43:44, and then makes the time adjustment. The value stored represents the time 04:43:44+00:00.

input @1 etz e8601tz.;

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

23:43:44-05:00

17024

23:43:44Z

85424

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