DDMMYYxw. Format

Writes date values in the form ddmm<yy>yy or dd-mm-yy<yy>, where the x in the format name is a character that represents the special character that separates the day, month, and year, which can be a hyphen (-), period (.), blank character, slash (/), colon (:), or no separator; the year can be either 2 or 4 digits.

Category: Date and Time
Alignment: Right

Syntax

DDMMYYxw.

Syntax Description

x

identifies a separator or specifies that no separator appear between the day, the month, and the year. The following are valid values for x:

B

separates with a blank

C

separates with a colon

D

separates with a hyphen

N

indicates no separator

P

separates with a period

S

separates with a slash.

w

specifies the width of the output field.

Default 8
Range 2–10
Interactions When w has a value of from 2 to 5, the date appears with as much of the day and the month as possible. When w is 7, the date appears as a two-digit year without separators.
When x has a value of N, the width range changes to 2–8.

Details

The DDMMYYxw. format writes SAS date values in the form ddmm<yy>yy or ddxmmx<yy>yy:
dd
is an integer that represents the day of the month.
x
is a specified separator.
mm
is an integer that represents the month.
<yy>yy
is a two-digit or four-digit integer that represents the year.

Example

The following examples use the input value of 19137, which is the SAS date value that corresponds to May 24, 2012.
SAS Statement
Result
----+----1----+
put date ddmmyyc5.;
24:05
put date ddmmyyd8.;
24-05-12
put date ddmmyyp10.;
24.05.2012
put date ddmmyyn8.;
24052012

See Also

Functions:
DAY Function in SAS Functions and CALL Routines: Reference
MDY Function in SAS Functions and CALL Routines: Reference
MONTH Function in SAS Functions and CALL Routines: Reference
YEAR Function in SAS Functions and CALL Routines: Reference
Informats: