DATDIF/YRDIF functions

anming — Wed, 25 Nov 2020 15:38:51 GMT

data scoredata1;
set scoredata0;
year_diff1 = YRDIF(start_date,today(),'30/360');
year_diff2 = YRDIF(start_date,'14sep2015'd,'ACT/ACT');
year_diff3 = YRDIF(start_date,today(),'ACT/360');
year_diff4 = YRDIF(start_date,'14sep2015'd,'ACT/365');

day_diff1 = datDIF(start_date,today(),'30/360');
day_diff2 = datDIF(start_date,'14sep2015'd,'ACT/ACT');

run;

when I run the codes above, I got different values due to different bases. How can I sue these values? or what are the significance of these differences?

Besides, why should we put 'd' after the date in date9 format?

Re: DATDIF/YRDIF functions

PaigeMiller — Wed, 25 Nov 2020 15:48:00 GMT

The documentation explains the differences

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=p1pmmr2dtec32an1vbsqmm3abil5.htm&locale=en

why should we put 'd' after the date in date9 format?

Formats are irrelevant, SAS does all calculations based upon the internal representation of the dates, which is the integer number of days since 01JAN1960. So whether the date is formatted or not, that's how it is represented. So when you use '14sep2015'd, the d at the end tells SAS to convert the date to the integer number of days since 01JAN1960, and now the math proceeds properly. If you leave of the d at the end, then SAS is trying to work with a character string '14sep2015' which is not a date and can't be evaluated in date arithmetic.

topic DATDIF/YRDIF functions in New SAS User

DATDIF/YRDIF functions

Re: DATDIF/YRDIF functions