i have two variables
date1 date2 diff (date2-date1)
20080101 20080104 3
20080101 20071230 -2
how do i calculate the difference date2-date1 as above? i wanted to know how many days over and under date2 is vs date1
thank you.
Hi:
If they are SAS date variables, you can just subtract them and then, if you want to get the absolute value, without a negative sign (since depending on your 2 numbers, you might get a negative DIFF), then you can just use the ABS function.
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.