| Date Intervals, Formats, and Functions |
Summary of Interval Types
The interval types are summarized as follows.
- YEAR
- specifies yearly intervals.
Abbreviations are YEAR, YEARS, YEARLY, YR, ANNUAL, ANNUALLY, ANNUALS.
The starting subperiod s is in months.
- SEMIYEAR
- specifies semiannual intervals (every six months).
Abbreviations are SEMIYEAR, SEMIYEARS, SEMIYEARLY, SEMIYR,
SEMIANNUAL, SEMIANN.
The starting subperiod s is in months.
For example, SEMIYEAR.3 intervals
are March -August and September -February.
- QTR
- specifies quarterly intervals (every three months).
Abbreviations are QTR, QUARTER, QUARTERS, QUARTERLY, QTRLY, QTRS.
The starting subperiod s is in months.
- MONTH
- specifies monthly intervals.
Abbreviations are MONTH, MONTHS, MONTHLY, MON.
The starting subperiod s is in months.
For example, MONTH2.2 intervals are February -March,
April -May, June -July, August -September, October -November,
and December -January of the following year.
- SEMIMONTH
- specifies semimonthly intervals.
SEMIMONTH breaks each month into two periods,
starting on the first and sixteenth day.
Abbreviations are SEMIMONTH, SEMIMONTHS, SEMIMONTHLY, SEMIMON.
The starting subperiod s is in SEMIMONTH periods.
For example, SEMIMONTH2.2 specifies intervals from the sixteenth
of one month through the fifteenth of the next month.
- TENDAY
- specifies ten-day intervals.
TENDAY breaks the month into three periods,
the first through the tenth day of the month,
the eleventh through the twentieth day of the month,
and the remainder of the month.
(TENDAY is a special interval typically used
for reporting automobile sales data.)
The starting subperiod s is in TENDAY periods.
For example, TENDAY4.2 defines forty-day periods
starting at the second TENDAY period.
- WEEK
- specifies weekly intervals of seven days.
Abbreviations are WEEK, WEEKS, WEEKLY.
The starting subperiod s is in days,
with the days of the week numbered as 1=Sunday,
2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, and 7=Saturday.
For example, WEEK.7 means weekly with Saturday as the first day of the week.
- WEEKDAY
- WEEKDAY17W
- specifies daily intervals with weekend days included in the
preceding week day.
Abbreviations are WEEKDAY, WEEKDAYS.
The WEEKDAY interval is the same as DAY except that weekend days
are absorbed into the preceding weekday. Thus there are
five WEEKDAY intervals in a calendar week: Monday, Tuesday,
Wednesday, Thursday, and the three-day period Friday-Saturday-Sunday.
The default weekend days are Saturday and Sunday, but any
one to six weekend days can be listed after the WEEKDAY string
and followed by a W.
Weekend days are specified as '1' for Sunday,
'2' for Monday, and so forth.
For example, WEEKDAY67W specifies a Friday-Saturday weekend.
WEEKDAY1W specifies a six-day work week with a Sunday weekend.
WEEKDAY17W is the same as WEEKDAY.
The starting subperiod s is in days.
- DAY
- specifies daily intervals.
Abbreviations are DAY, DAYS, DAILY.
The starting subperiod s is in days.
- HOUR
- specifies hourly intervals.
Abbreviations are HOUR, HOURS, HOURLY, HR.
The starting subperiod s is in hours.
- MINUTE
- specifies minute intervals.
Abbreviations are MINUTE, MINUTES, MIN.
The starting subperiod s is in minutes.
- SECOND
- specifies second intervals.
Abbreviations are SECOND, SECONDS, SEC.
The starting subperiod s is in seconds.
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
