topic INTNX CALCULATION in SAS Programming

INTNX CALCULATION

HeatherNewton — Thu, 20 Jul 2023 03:46:56 GMT

DATE_STATEMENT_START=INTNX("MONTH",DATE_STATEMENT,-1)+DAY(DATE_STATEMENT)-1;

how to interpret this?

if DATE_STATEMENT is 20Nov2022

DATE_STATEMENT_START=20Oct2022+20-1

and what is the answer?

what if date_statement is 30Nov2022

what is intnx("MONTH",DATE_STATEMENT,-1) 30Oct2022 or 31Oct2022?

Re: INTNX CALCULATION

john_mccall — Thu, 20 Jul 2023 04:10:08 GMT

Hi.

Trying to draft an example per your notes. Please try the following and if this is not what you are looking for, shed more light on your goal. Thanks.

Data Test;
Date='20NOV2022'd;
Day=day(date);
DateNext=intnx('month',Date,-1,'same')+ Day-1;
format date datenext date9.;
run;

proc print data=test;
title "Values for Date, Day and DateNext";
run;

Re: INTNX CALCULATION

HeatherNewton — Thu, 20 Jul 2023 04:18:44 GMT

so if I dont put b or e in intnx("MONTH",DATE_STATEMENT,-1)

It will always means same date no matter what date_statement is?

what if 31oct 2022, is it going to give 30sep2022

and 31mar2022 will give 28feb2022?

and 11oct2022 will give 11sep2022 as same date is assumed...

Re: INTNX CALCULATION

john_mccall — Thu, 20 Jul 2023 04:37:55 GMT

If you do not specify the fourth argument 'same' or 's' in intnx('month',Date,-1,'same'), the date will always be the first day of the month requested. As you indicated, you can type 'e' for end, 'm' for middle, 's' for same, or 'b' for begin which is the default.

Re: INTNX CALCULATION

Kurt_Bremser — Thu, 20 Jul 2023 05:41:11 GMT

As always, Maxim 1: Read the Documentation!

INTNX Function

If no fourth argument is specified, the aligment defaults to "BEGINNING", so with a month interval you always get the first of the month. Adding the DAY value and subtracting 1 will result in the same day one month back, with the peculiar twist of what happens when you are at the end of a month with more days than the previous month. If you apply this on July 31, you get July 1 instead of June 30 (which would be the result of INTNX with a SAME alignment) .