topic Re: Intck in SAS Programming

Intck

HeatherNewton — Tue, 04 Oct 2022 04:20:32 GMT

I have a condition

Where intck(‘month’, transaction_post_date, “&sampdate.”D)=0;

What does it mean?

Re: Intck

HeatherNewton — Tue, 04 Oct 2022 04:22:55 GMT

Is it equal to the condition
Where transaction_post_date>=intnx(“month”,”&sampdate.”d,-12,”B”)
?

Re: Intck

Kurt_Bremser — Wed, 05 Oct 2022 09:36:10 GMT

No. When the result of INTCK is 0, it means that both dates are within the same interval. Your condition would also validate all dates after the month.

Study the documentation of the INTCK Function

Edit: fixed a typo

Re: Intck

HeatherNewton — Wed, 05 Oct 2022 09:22:02 GMT

What if I add one more line to Code A

Code A is as follows:

Where trasaction_post_date >=intnx(“month”,”&sampdate.”d,-12,”B”)
And transaction_post_date<=“&sampdate.”d

If today is sampdate, trasaction_post_date in code A refers to dates from 1st Oct 2021

Code B is as follows:
Where intck(‘month’,’transaction_post_date,”&sampdate.”d)=0;

If today is sampdate, transaction_post_date in Code B refers to any dates within Oct 2022...

Is my interpretation above correct?

Re: Intck

Kurt_Bremser — Wed, 05 Oct 2022 09:37:36 GMT

These conditions would only be equivalent if &sampdate was the last day of the month.