Previous Page | Next Page

Informats

DDMMYYw. Informat



Reads date values in the form ddmmyy<yy> or dd-mm-yy<yy>, where a special character, such as a hyphen (-), period (.), or slash (/), separates the day, month, and year; the year can be either 2 or 4 digits.
Category: Date and Time

Syntax
Syntax Description
Details
Examples
See Also

Syntax

DDMMYYw.


Syntax Description

w

specifies the width of the input field.

Default: 6
Range: 6-32

Details

The date values must be in the form ddmmyy<yy> or ddxmmxyy<yy>, where

dd

is an integer from 01 through 31 that represents the day of the month.

mm

is an integer from 01 through 12 that represents the month.

yy or yyyy

is a two-digit or four-digit integer that represents the year.

x

is a separators that can be any special character or a blank.:

If you use separators, place them between all the values. Blanks can also be placed before and after the date. Make sure the width of the input field allows space for blanks and special characters.

Note:   SAS interprets a two-digit year as belonging to the 100-year span that is defined by the YEARCUTOFF= system option.  [cautionend]


Examples

input calendar_date ddmmyy10.;

Data Line Results
----+----1----+

160308
17607
16/03/08
17607
16-03-2008
17607
16 03 2008
17607


See Also

Formats:

DATEw. Format

DDMMYYw. Format

MMDDYYw. Format

YYMMDDw. Format

Function:

MDY Function

Informats:

DATEw. Informat

MMDDYYw. Informat

YYMMDDw. Informat

System Option:

YEARCUTOFF= System Option

Previous Page | Next Page | Top of Page