Hands-On SAS for Data Analysis

INTNX and INTCK

The most useful functions for calculating date values, datetime values, and time intervals are INTNX and INTCK. These functions help in interval calculations. In common coding parlance, you can refer to INTNX as an interval check and INTCK as an interval next function. What this means is that INTNX checks for intervals whereas INTCK is useful for computing a date/datetime value on the basis of a different date/datetime value. Apart from this difference, there is a minor difference in the syntax. The INTNX function has four arguments, whereas the INTCK function has three arguments. The first two arguments are the same for both functions:

• interval: A character constant or variable that contains an interval name
• from: An SAS ...