topic Re: Why I get different answers for intck year and yr dif? Both shouldn't be giving the same answers in New SAS User

Why I get different answers for intck year and yr dif? Both shouldn't be giving the same answers?

POOJA_J — Sat, 26 Nov 2022 16:15:51 GMT

data demo;
input pid bdate: date9. svdate: date9.;
format bdate svdate date9.;

days=intck('day',bdate,svdate);
months=intck('month',bdate,svdate);
years=intck('year',bdate,svdate);
usingyrdiff= int(yrdif(bdate, svdate, 'actual'));  
cards;
101 19mar1978 14feb2005
102 20may1975 19mar2006
;
run;
proc print data=demo;
run;

Re: Why I get different answers for intck year and yr dif? Both shouldn't be giving the same answers

Cynthia_sas — Sat, 26 Nov 2022 16:22:13 GMT

Hi:

Take a look at this blog article. I think it explains your experience with INTCK https://blogs.sas.com/content/iml/2017/05/15/intck-intnx-intervals-sas.html . Basically, INTCK returns the number of "boundary dates" that have passed. So you need to control for that. There are also some good references at the end of the article.

Cynthia

Re: Why I get different answers for intck year and yr dif? Both shouldn't be giving the same answers

PaigeMiller — Sat, 26 Nov 2022 16:34:53 GMT

data demo;
input pid bdate: date9. svdate: date9.;
format bdate svdate date9.;

days=intck('day',bdate,svdate,'c');
months=intck('month',bdate,svdate,'c');
years=intck('year',bdate,svdate,'c');
usingyrdiff= int(yrdif(bdate, svdate, 'actual'));  
cards;
101 19mar1978 14feb2005
102 20may1975 19mar2006
;
run;

Re: Why I get different answers for intck year and yr dif? Both shouldn't be giving the same answers

Kurt_Bremser — Sat, 26 Nov 2022 16:48:24 GMT

In its default setting, INTCK counts the number of interval boundaries between the values. Somebody born on December 31 will be one year old on January 1. To avoid this, you must use the "c" (continuous) modifier.