Reads time values that are specified in the ISO 8601 extended
time notation hh:mm:ss+|-hh:mm.ffffff or hh:mm:ssZ.
Category: |
Date and Time
|
|
ISO
8601
|
Alignment: |
left
|
Alias: |
IS8601TZ
|
Time Zone Informat: |
Yes
|
ISO 8601 Element: |
5.3.1.1 Complete representation
|
- 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.
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.;
Data Line |
Results |
----+----1----+----2
|
|
23:43:44-05:00
|
17024
|
23:43:44Z
|
85424
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.