Date Intervals, Formats, and Functions |
Date Formats |
Table 4.3 lists some of the date formats available in SAS. For each format, an example is shown of a date value in the notation produced by the format. The date '17OCT91'D is used as the example.
Format |
Width |
Default |
|
---|---|---|---|
Example |
Description |
Range |
Width |
DATEw. |
day, month abbreviation, year: |
5–9 |
7 |
17OCT91 |
ddmonyy |
||
DAYw. |
day of month |
2–32 |
2 |
17 |
|||
DDMMYYw. |
day, month, year: dd/mm/yy |
2–8 |
8 |
17/10/91 |
|||
DOWNAMEw. |
name of day of the week |
1–32 |
9 |
Thursday |
|||
JULDAYw. |
day of year |
3–32 |
3 |
290 |
|||
JULIANw. |
year and day of year: yyddd |
5–7 |
5 |
91290 |
|||
MMDDYYw. |
month, day, year: mm/dd/yy |
2–8 |
8 |
10/17/91 |
|||
MMYYw. |
month and year: mmMyy |
5–32 |
7 |
10M1991 |
|||
MMYYCw. |
month and year: mm:yy |
5–32 |
7 |
10:1991 |
|||
MMYYDw. |
month and year: mm-yy |
5–32 |
7 |
10-1991 |
|||
MMYYPw. |
month and year: mm.yy |
5–32 |
7 |
10.1991 |
|||
MMYYSw. |
month and year: mm/yy |
5–32 |
7 |
10/1991 |
|||
MMYYNw. |
month and year: mmyy |
5–32 |
6 |
101991 |
|||
MONNAMEw. |
name of month |
1–32 |
9 |
October |
|||
MONTHw. |
month of year |
1–32 |
2 |
10 |
|||
MONYYw. |
month abbreviation and year: |
5–7 |
5 |
OCT91 |
monyy |
||
|
quarter of year |
1–32 |
1 |
4 |
|||
QTRRw. |
quarter in roman numerals |
3–32 |
3 |
IV |
|||
NENGOw. |
Japanese Nengo notation |
2–10 |
10 |
H.03/10/17 |
|||
WEEKDATEw. |
day-of-week, month-name dd, yy |
3–37 |
29 |
Thursday, October 17, 1991 |
|||
WEEKDATXw. |
day-of-week, dd month-name yy |
3–37 |
29 |
Thursday, 17 October 1991 |
|||
WEEKDAYw. |
day of week |
1–32 |
1 |
5 |
|||
WEEKVw. |
ISO 8601 year, week, day of week: |
3–200 |
11 |
1991-W42-04 |
yyyy-Www-dd |
||
WORDDATEw. |
month-name dd, yy |
3–32 |
18 |
October 17, 1991 |
|||
WORDDATXw. |
dd month-name yy |
3–32 |
18 |
17 October 1991 |
|||
YEARw. |
year |
2–32 |
4 |
1991 |
|||
YYMMw. |
year and month: yyMmm |
5–32 |
7 |
1991M10 |
|||
YYMMCw. |
year and month: yy:mm |
5–32 |
7 |
1991:10 |
|||
YYMMDw. |
year and month: yy-mm |
5–32 |
7 |
1991-10 |
|||
YYMMPw. |
year and month: yy.mm |
5–32 |
7 |
1991.10 |
|||
YYMMSw. |
year and month: yy/mm |
5–32 |
7 |
1991/10 |
|||
YYMMNw. |
year and month: yymm |
5–32 |
7 |
199110 |
|||
YYMONw. |
year and month abbreviation: |
5–32 |
7 |
1991OCT |
yyMON |
||
YYMMDDw. |
year, month, day: yy/mm/dd |
2–8 |
8 |
91/10/17 |
|||
YYQw. |
year and quarter: yyQq |
4–6 |
4 |
91Q4 |
|||
YYQCw. |
year and quarter: yy:q |
4–32 |
6 |
1991:4 |
|||
YYQDw. |
year and quarter: yy-q |
4–32 |
6 |
1991-4 |
|||
YYQPw. |
year and quarter: yy.q |
4–32 |
6 |
1991.4 |
|||
YYQSw. |
year and quarter: yy/q |
4–32 |
6 |
1991/4 |
|||
YYQNw. |
year and quarter: yyq |
3–32 |
5 |
19914 |
|||
YYQRw. |
year and quarter in roman |
6–32 |
8 |
1991QIV |
numerals: yyQrr |
||
YYQRCw. |
year and quarter in roman |
6–32 |
8 |
1991:IV |
numerals: yy:rr |
||
YYQRDw. |
year and quarter in roman |
6–32 |
8 |
1991-IV |
numerals: yy-rr |
||
YYQRPw. |
year and quarter in roman |
6–32 |
8 |
1991.IV |
numerals: yy.rr |
||
YYQRSw. |
year and quarter in roman |
6–32 |
8 |
1991/IV |
numerals: yy/rr |
||
YYQRNw. |
year and quarter in roman |
6–32 |
8 |
1991IV |
numerals: yyrr |
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.