To understand more about dates and times in SAS you can read:
https://support.sas.com/resources/papers/proceedings15/1334-2015.pdf
https://communities.sas.com/t5/Ask-the-Expert/Tips-and-Tricks-for-Working-with-Dates-and-Times-in-SAS-Q-amp-A/ta-p/813974
https://documentation.sas.com/doc/en/lrcon/9.4/p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm
For a way to compare see the following code:
data _null_;
date1 = 22459;
date2 = mdy(5, 7, 2021);
days_between_1_2 = intck('day', date1, date2);
days_between_2_1 = intck('day', date2, date1);
formatted_date1 = date1;
formatted_date2 = date2;
format formatted_date1 formatted_date2 date9.;
put date1= '|' formatted_date1= /
date2= '|' formatted_date2= /
'days_between date1 and date2 is ' days_between_1_2 /
'days_between date2 and date1 is ' days_between_2_1;
run;
... View more