BookmarkSubscribeRSS Feed
aarony
Obsidian | Level 7

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. 

 

3 REPLIES 3
Cynthia_sas
Diamond | Level 26
Hi, I you run PROC CONTENTS on DATE1 and DATE2, are they character variables or are they SAS date variables? The method you use to calculate the difference will be easy, once the dates are stored as SAS date values (the number of days since Jan 1, 1960.

cynthia
aarony
Obsidian | Level 7
Hi Cynthia. They are date variables.
Thanks for your reply.
Cynthia_sas
Diamond | Level 26

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

diff_days.png

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 4302 views
  • 2 likes
  • 2 in conversation