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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.