The SAS intnx function, which is used to increment the date with a number of intervals, is an interval name that can appear in uppercase and lowercase characters. It has a possible set of values in the interval that splits the category, Interval, Starting point, and Shift period, which i...
Are you attempting to invoke a macro, or are you intending to call the INTNX() function? Can you describe a bit more about what you are trying to do? What is the value of the macro variable MESREF? Meaning, what do you get in the log if you submit: %put &=mesref ; I'm guess...
I am using the intnx function to estimate new dates based on the interval. In term of interval, I am trying to find the documentation on it. Maybe I am not lucky. it could be day, week, month, quarter and year. What's the name of a four months interval.? How do we define a ...
WARNING: An argument to the function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. Which argument to INTNX is...
Do note however, I doubt today() will work as that is a SAS function. If your passing SQL through to the database, then you need to use SQL and functions appropriate to the SQL database, you would need to use SYSDATE or CURRENT_DATE according to the Oracle documents: https...