DATA Step, Macro, Functions and more

how to count days between two variables (negative and positive)

Reply
Frequent Contributor
Posts: 102

how to count days between two variables (negative and positive)

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. 

 

SAS Super FREQ
Posts: 8,865

Re: how to count days between two variables (negative and positive)

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
Frequent Contributor
Posts: 102

Re: how to count days between two variables (negative and positive)

Posted in reply to Cynthia_sas
Hi Cynthia. They are date variables.
Thanks for your reply.
SAS Super FREQ
Posts: 8,865

Re: how to count days between two variables (negative and positive)

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

Ask a Question
Discussion stats
  • 3 replies
  • 202 views
  • 2 likes
  • 2 in conversation