Table 4.3 lists some of the available SAS date formats. 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.
Table 4.3: Frequently Used SAS Date Formats
Format and |
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: mmMyyyy |
5–32 |
7 |
10M1991 |
|||
MMYYCw. |
Month and year: mm:yyyy |
5–32 |
7 |
10:1991 |
|||
MMYYDw. |
Month and year: mm-yyyy |
5–32 |
7 |
10-1991 |
|||
MMYYPw. |
Month and year: mm.yyyy |
5–32 |
7 |
10.1991 |
|||
MMYYSw. |
Month and year: mm/yyyy |
5–32 |
7 |
10/1991 |
|||
MMYYNw. |
Month and year: mmyyyy |
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 |
||
QTRw. |
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, yyyy |
3–37 |
29 |
Thursday, October 17, 1991 |
|||
WEEKDATXw. |
day-of-week, dd month-name yyyy |
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, yyyy |
3–32 |
18 |
October 17, 1991 |
|||
WORDDATXw. |
dd month-name yyyy |
3–32 |
18 |
17 October 1991 |
|||
YEARw. |
Year: yyyy |
2–32 |
4 |
1991 |
|||
YYMMw. |
Year and month: yyyyMmm |
5–32 |
7 |
1991M10 |
|||
YYMMCw. |
Year and month: yyyy:mm |
5–32 |
7 |
1991:10 |
|||
YYMMDw. |
Year and month: yyyy-mm |
5–32 |
7 |
1991-10 |
|||
YYMMPw. |
Year and month: yyyy.mm |
5–32 |
7 |
1991.10 |
|||
YYMMSw. |
Year and month: yyyy/mm |
5–32 |
7 |
1991/10 |
|||
YYMMNw. |
Year and month: yyyymm |
5–32 |
7 |
199110 |
|||
YYMONw. |
Year and month abbreviation: |
5–32 |
7 |
1991OCT |
yyyymon |
||
YYMMDDw. |
Year, month, day: yy/mm/dd |
2–8 |
8 |
91/10/17 |
|||
YYQw. |
Year and quarter: yyyyQq |
4–6 |
6 |
1991Q4 |
|||
YYQCw. |
Year and quarter: yyyy:q |
4–32 |
6 |
1991:4 |
|||
YYQDw. |
Year and quarter: yyyy-q |
4–32 |
6 |
1991-4 |
|||
YYQPw. |
Year and quarter: yyyy.q |
4–32 |
6 |
1991.4 |
|||
YYQSw. |
Year and quarter: yyyy/q |
4–32 |
6 |
1991/4 |
|||
YYQNw. |
Year and quarter: yyyyq |
3–32 |
5 |
19914 |
|||
YYQRw. |
Year and quarter in roman |
6–32 |
8 |
1991QIV |
numerals: yyyyQrr |
||
YYQRCw. |
Year and quarter in roman |
6–32 |
8 |
1991:IV |
numerals: yyyy:rr |
||
YYQRDw. |
Year and quarter in roman |
6–32 |
8 |
1991-IV |
numerals: yyyy-rr |
||
YYQRPw. |
Year and quarter in roman |
6–32 |
8 |
1991.IV |
numerals: yyyy.rr |
||
YYQRSw. |
Year and quarter in roman |
6–32 |
8 |
1991/IV |
numerals: yyyy/rr |
||
YYQRNw. |
Year and quarter in roman |
6–32 |
8 |
1991IV |
numerals: yyyyrr |