topic Re: What is the difference between two dates in SAS Programming

What is the difference between two dates

thanikondharish — Fri, 26 Apr 2019 04:22:47 GMT

Diff=intck('week','31dec2018'd,'01jan2019'd,'c');

Diff1=intck('week','31dec2018'd,'01jan2019'd,'d');

If I use above code I am getting '0' for both variables .
Can you explain?

Re: What is the difference between two dates

ChrisNZ — Fri, 26 Apr 2019 04:38:12 GMT

These dates are a Monday and a Tuesday, so are in the same week.

Note that weeks start on Sunday -not Monday- in the crazy world of SAS week functions (might be a US thing).

Use 'week.2' to start the week en Monday.

Finally, the 'c' parameter shifts the start of the week to the first date.

Re: What is the difference between two dates

SASKiwi — Fri, 26 Apr 2019 04:44:08 GMT

The INTCK function only counts whole intervals. The "C" - continuous - option counts whole weeks so until you have 7 days between the start and end date the result will be 0. The "D" - discrete option counts interval boundaries. By default the WEEK boundary is Saturday to Sunday. Your dates cover Monday to Tuesday so they don't cover a week boundary, so the result is also 0.

Re: What is the difference between two dates

thanikondharish — Fri, 26 Apr 2019 04:55:18 GMT

Thanq .I understood

Re: What is the difference between two dates

thanikondharish — Fri, 26 Apr 2019 04:55:19 GMT

Thanq.I understood