Date Intervals, Formats, and Functions |
Examples of Interval Specifications |
Table 4.1 shows examples of different kinds of interval specifications.
Name |
Kind of Interval |
YEAR |
years that start in January |
YEAR.10 |
fiscal years that start in October |
YEAR2.7 |
biennial intervals that start in July of even years |
YEAR2.19 |
biennial intervals that start in July of odd years |
YEAR4.11 |
four-year intervals that start in November of leap years (frequency of U.S. presidential elections) |
YEAR4.35 |
four-year intervals that start in November of even years between leap years (frequency of U.S. midterm elections) |
WEEK |
weekly intervals that start on Sundays |
WEEK2 |
biweekly intervals that start on first Sundays |
WEEK1.1 |
same as WEEK |
WEEK.2 |
weekly intervals that start on Mondays |
WEEK6.3 |
six-week intervals that start on first Tuesdays |
WEEK6.11 |
six-week intervals that start on second Wednesdays |
WEEKDAY |
daily with Friday-Saturday-Sunday counted as the same day (five-day work week with a Saturday-Sunday weekend) |
WEEKDAY17W |
same as WEEKDAY |
WEEKDAY5.2 |
five weekdays that start on Monday. If WEEKDAY data are accumulated into weekly data, the interval of the accumulated data is WEEKDAY5.2 |
WEEKDAY67W |
daily with Thursday-Friday-Saturday counted as the same day (five-day work week with a Friday-Saturday weekend) |
WEEKDAY1W |
daily with Saturday-Sunday counted as the same day (six-day work week with a Sunday weekend) |
WEEKDAY3.2 |
three-weekday intervals (with Friday-Saturday-Sunday counted as one weekday) with the cycle three-weekday periods aligned to Monday 4 Jan 1960 |
HOUR8.7 |
eight-hour intervals that start at 6 a.m., 2 p.m., and 10 p.m. (might be used for work shifts) |
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.