topic Re: INTCK Function in SAS Programming

INTCK Function

buechler66 — Tue, 10 Sep 2019 13:55:56 GMT

Hi all. I run this same code only changing the first parameter of the INTCK function from "month" to "day" to "week". For "month" it returns 12 as expected. For "day" it returns 365 rows as expected. But for "week" it returns 53 when I would expect 52. Any reason I'd be getting this unexpected result?

proc sql;
create table tmp as
select distinct
1 + INTCK ("day", '01JUN2018'D, '31MAY2019'D) AS MY_NUMBER
FROM temp;
quit;

Re: INTCK Function

PaigeMiller — Tue, 10 Sep 2019 13:58:54 GMT

A year, 365 or 366 days, is actually slightly longer than 52 weeks, which would be 52*7 = 364 days.

Re: INTCK Function

buechler66 — Tue, 10 Sep 2019 14:00:21 GMT

Makes sense. Thank you.

Re: INTCK Function

PeterClemmensen — Tue, 10 Sep 2019 14:02:40 GMT

A year can not contain 53 full weeks, but there can be 53 week interval boundaries crossed in a full year, which is what the INTCK Function measures.