MMYYxw. Format

Writes date values in the form mm<yy>yy or mm-<yy>yy, where the x in the format name is a character that represents the special character that separates the month and the 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

MMYYxw.

Syntax Description

x

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

C

separates with a colon.

D

separates with a hyphen.

N

indicates no separator.

P

separates with a period.

S

separates with a forward slash.

w

specifies the width of the output field.

Default 7
Range 5–32
Interactions When x is set to N, no separator is specified. The width range is then 4–32, and the default changes to 6.
When x has a value of C, D, P, or S and w has a value of 5 or 6, the date appears with only the last two digits of the year. When w is 7 or more, the date appears with a four-digit year.
When x has a value of N and w has a value of 4 or 5, the date appears with only the last two digits of the year. When x has a value of N and w is 6 or more, the date appears with a four-digit year.

Details

The MMYYxw. format writes SAS date values in one of the following forms:
mm<yy>yy
mmx<yy>yy
where
mm
is an integer that represents the month.
x
is a specified separator.
<yy>yy
is a two-digit or four-digit integer that represents the year.

Example

The following examples use the input value of 19127, which is the SAS date value that corresponds to May 14, 2012.
SAS Statement
Result
 
----+----1----+
put date mmyyc5.;
05:12
put date mmyyd.;
05-2012
put date mmyyn4.;
0512
put date mmyyp8.;
 05.2012
put date mmyys10.;
   05/2012

See Also