ISO 8601 SAS Formats and Informats

SAS Informats for the Basic Format

This set of SAS informats represents the ISO 8601 basic format. The ND part of the informat's syntax designates non-delimited.

Note: Because using the basic format in XML content is discouraged, it is recommended that when you read in values with one of the basic format SAS informats, you write values with the corresponding extended format SAS format. [cautionend]

ND8601DA Informat

Syntax: ND8601DA

Category: Date

ISO 8601 Element: 5.2.1.1 Complete representation

The ND8601DA informat reads date values into a variable in the basic format YYYYMMDD, where

YYYY: is a four-digit year including century, for example, 2003.
MM: is a two-digit month (zero padded), for example, 01 is January.
DD: is a two-digit day of the month (zero padded), that is, 01 through 31.

ND8601DN Informat

Syntax: ND8601DN

Category: Datetime

Time Zone: No

ISO 8601 Element: 5.2.1.1 Complete representation

The ND8601DN informat reads datetime values with only a date portion into a variable in the basic format YYYYMMDD, where

YYYY: is a four-digit year including century, for example, 2003.
MM: is a two-digit month (zero padded), for example, 01 is January.
DD: is a two-digit day of the month (zero padded), that is, 01 through 31.

ND8601DT Informat

Syntax: ND8601DT

Category: Datetime

Time Zone: No

ISO 8601 Element: 5.4.1 Complete representation

The ND8601DT informat reads datetime values into a variable in the basic format YYYYMMDDhhmmss.[fffff], where

YYYY: is a four-digit year including century, for example, 2003.
MM: is a two-digit month (zero padded), for example, 01 is January.
DD: is a two-digit day of the month (zero padded), that is, 01 through 31.
hh: is a two-digit hour (zero padded), that is, 00 through 23.
mm: is a two-digit minute (zero padded), that is, 00 through 59.
ss: is a two-digit second (zero padded), that is, 00 through 59.
.fffff: are optional fractional seconds.

ND8601DZ Informat

Syntax: ND8601DZ

Category: Datetime

Time Zone: Yes

ISO 8601 Element: 5.4.1 Complete representation

The ND8601DZ informat reads datetime values with a time zone into a variable in the basic format YYYYMMDDhhmmss[.fffff][[+|-]hhmm], where

YYYY: is a four-digit year (zero padded), for example, 2003.
MM: is a two-digit month (zero padded), for example, 01 is January.
DD: is a two-digit day of the month (zero padded), that is, 01 through 31.
hh: is a two-digit hour (zero padded), that is, 00 through 23.
mm: is a two-digit minute (zero padded), that is, 00 through 59.
ss: is a two-digit second (zero padded), that is, 00 through 59.
.fffff: are optional fractional seconds.
+|-hhmm: is an optional hour and minute signed offset from UTC base. Note that the offset must be +|-hhmm (that is, + or - and four characters). The shorter form +|-hh is not supported.

ND8601TM Informat

Syntax: ND8601TM

Category: Time

Time Zone: No

ISO 8601 Element: 5.3.1.1 Complete representation and 5.3.1.3 Representation of decimal fractions

The ND8601TM informat reads time values into a variable in the basic format hhmmss, where

hh: is a two-digit hour (zero padded), that is, 00 through 23.
mm: is a two-digit minute (zero padded), that is, 00 through 59.
ss: is a two-digit second (zero padded), that is, 00 through 59.

ND8601TZ Informat

Syntax: ND8601TZ

Category: Time

Time Zone: Yes

ISO 8601 Element: 5.3.1.1 Complete representation

The ND8601TZ informat reads time values with a time zone into a variable in the basic format hhmmss[.fffff][[+|-]hhmm], where

hh: is a two-digit hour (zero padded), that is, 00 through 23.
mm: is a two-digit minute (zero padded), that is, 00 through 59.
ss: is a two-digit second (zero padded), that is, 00 through 59.
.fffff: are optional fractional seconds.
+|-hhmm: is an optional hour and minute signed offset from UTC base. Note that the offset must be +|-hhmm (that is, + or - and four characters). The shorter form +|-hh is not supported.

Top of Page