NOTE: The query requires remerging summary statistics back with the original data.
This means that you have a column in the SELECT that is neither the argument of a summary function, nor part of the GROUP BY clause. Instead of just having one observation per group, the original number of observations is taken, and the result(s) of the summary function(s) are stored in each observation.
Fix your SELECT and GROUP BY, if you did not intend this.
NOTE: Invalid (or missing) arguments to the INTCK function have caused the function to return a missing value.
What it says. You have values in the columns used in the INTCK functions that can't be computed, so it returns missing values. Check your data.
NOTE: Invalid argument to function YRDIF. Missing values may be generated.
Same as above. Check your data.
NOTE: Invalid argument to function YRDIF. Missing values may be generated.
This is a NOTE you will always get; it simply notifies you of the basic outline of the resulting dataset.
It mostly boils down to Maxim 3: Know Your Data.
Inspect your dataset, especially paying attention to the formats used, so you get a clue about the raw values stored in there. It might be that you try to use a datetime where a date is expected.
... View more