|
?
| Task |
Type of Language Element |
Language Element |
Input |
Result |
| Write SAS date values in recognizable forms |
Date formats |
DATE. |
19434 |
17MAR13 |
| DATE9. |
19434 |
17MAR2013 |
| DAY. |
19434 |
17 |
| DDMMYY. |
19434 |
17/03/13 |
| DDMMYY10. |
19434 |
17/03/2013 |
| DDMMYYB. |
19434 |
17 03 13 |
| DDMMYYB10. |
19434 |
17 03 2013 |
| DDMMYYC. |
19434 |
17:03:13 |
| DDMMYYC10. |
19434 |
17:03:2013 |
| DDMMYYD. |
19434 |
17-03-13 |
| DDMMYYD10. |
19434 |
17-03-2013 |
| DDMMYYN. |
19434 |
17032013 |
| DDMMYYN6. |
19434 |
170313 |
| DDMMYYP. |
19434 |
17.03.13 |
| DDMMYYP10. |
19434 |
17.03.2013 |
| DDMMYYS. |
19434 |
17/03/13 |
| DDMMYYS10. |
19434 |
17/03/2013 |
| DOWNAME. |
19434 |
Sunday |
| JULDAY. 1 |
19434 |
76 |
| JULIAN. 1 |
19434 |
13076 |
| MMDDYY. |
19434 |
03/17/13 |
| MMDDYY10. |
19434 |
03/17/2013 |
| MMDDYYB. |
19434 |
03 17 13 |
| MMDDYYB10. |
19434 |
03 17 2013 |
| MMDDYYC. |
19434 |
03:17:13 |
| MMDDYYC10. |
19434 |
03:17:2013 |
| MMDDYYD. |
19434 |
03-17-13 |
| Write SAS date values in recognizable forms |
Date formats |
MMDDYYD10. |
19434 |
03-17-2013 |
| MMDDYYN. |
19434 |
03172013 |
| MMDDYYN8. |
19434 |
03172013 |
| MMDDYYP. |
19434 |
03.17.13 |
| MMDDYYP10. |
19434 |
03.17.2013 |
| MMDDYYS. |
19434 |
03/17/13 |
| MMDDYYS10. |
19434 |
03/17/2013 |
| MMYY. |
19434 |
03M2013 |
| MMYYC. |
19434 |
03:2013 |
| MMYYD. |
19434 |
03-2013 |
| MMYYN. |
19434 |
032013 |
| MMYYP. |
19434 |
03.2013 |
| MMYYS. |
19434 |
03/2013 |
| MONNAME. |
19434 |
March |
| MONTH. |
19434 |
3 |
| MONYY. |
19434 |
MAR13 |
| PDJULG. 1 |
19434 |
2013076F |
| PDJULI. 1 |
19434 |
0100076F |
| WEEKDATE. |
19434 |
Sunday, March 17, 2013 |
| WEEKDAY. |
19434 |
1 |
| WORDDATE. |
19434 |
March 17, 2013 |
| WORDDATX. |
19434 |
17 March 2013 |
| Quarter formats |
QTR. |
19434 |
1 |
| QTRR. |
19434 |
I |
| Time formats |
TIME. |
19434 |
5:23:54 |
| TIMEAMPM. |
19434 |
5:23:54 AM |
| TOD. |
19434 |
05:23:54 |
| Write SAS date values in recognizable forms |
Year formats |
YEAR. |
19434 |
2013 |
| YYMM. |
19434 |
2013M03 |
| YYMMC. |
19434 |
2013:03 |
| YYMMD. |
19434 |
2013-03 |
| YYMMP. |
19434 |
2013.03 |
| YYMMS. |
19434 |
2013/03 |
| YYMMN. |
19434 |
201303 |
| YYMMDD. |
19434 |
13-03-17 |
| YYMON. |
19434 |
2013MAR |
| Year/Quarter formats |
YYQ. |
19434 |
2013Q1 |
| YYQC. |
19434 |
2013:1 |
| YYQD. |
19434 |
2013-1 |
| YYQP. |
19434 |
2013.1 |
| YYQS. |
19434 |
2013/1 |
| YYQN. |
19434 |
20131 |
| YYQR. |
19434 |
2013QI |
| YYQRC. |
19434 |
2013:I |
| YYQRD. |
19434 |
2013-I |
| YYQRP. |
19434 |
2013.I |
| YYQRS. |
19434 |
2013/I |
| YYQRN. |
19434 |
2013I |
| 1In SAS, a Julian date is a date in the form YYNNN or YYYYNNN, where YY is a two-digit year, YYYY is a four-digit year, and NNN is the ordinal offset from January 1 of the year YY or YYYY. SAS processes Julian dates only for valid SAS dates. |
Tasks with Dates and Times, Part 2
| Task |
Type of Language Element |
Language Element |
Input |
Result |
| Date Tasks |
| Read calendar dates as SAS date Note: YEARCUTOFF=1926 |
Date informats |
DATE. |
17MAR13 |
19434 |
| ? |
? |
DATE9. |
17MAR2013 |
19434 |
| ? |
? |
DDMMYY. |
170313 |
19434 |
| ? |
? |
DDMMYY8. |
17032013 |
19434 |
| ? |
? |
JULIAN. 1 |
13076 |
19434 |
| ? |
? |
JULIAN7. 1 |
2013077 |
19434 |
| ? |
? |
MMDDYY. |
031713 |
19434 |
| ? |
? |
MMDDYY8. |
03172013 |
19434 |
| ? |
? |
MONYY. |
MAR13 |
19418 |
| ? |
? |
YYMMDD. |
130317 |
19434 |
| ? |
? |
YYMMDD8. |
20130317 |
19434 |
| ? |
? |
YYQ. |
13q1 |
19359 |
| ? |
? |
DATETIME |
17MAR2013 00:00:00 |
1679097600 |
| ? |
? |
TIME |
14:45:32 |
53132 |
| Return today's date as a SAS date value |
Date functions |
DATE() or TODAY() (equivalent) |
( ) |
The SAS date value for today. |
| Extract calendar dates from SAS |
Date functions |
DAY |
19434 |
17 |
|