The SAMEDAY alignment, first implemented in SAS^® 9.1, supports only single, non-shifted date intervals. If other intervals are specified, no error or warning is generated and INTNX might return incorrect results. If the interval specified is a datetime, the time portion of the datetime result returned by INTNX may be midnight, even if the time portion of the "start-from" datetime value is not midnight. If a multiple or shifted interval is specified, the SAMEDAY alignment may also return incorrect results. For example, prior to SAS 9.2.:

produces:

Beginning in SAS 9.2 the SAMEDAY alignment supports multiple, shifted, time, and datetime intervals. The value returned is aligned with respect to the shift period for the interval specified. Intervals' shift periods are documented in the "About Date and Time Intervals" section of the Dates, Times and Intervals chapter of the SAS Language Reference: Concepts. In the example above, since the shift period for the MONTH12 interval is MONTH, the result is aligned with respect to the month of the "start-from" date.

Select the Hot Fix tab in this note to access the hot fix for this issue.

This fix contains a new function called TINTNX which implements the new (9.2) behavior:

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :