topic how to count days between two variables (negative and positive) in SAS Programming

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

aarony — Mon, 02 Jan 2017 17:48:41 GMT

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.

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

Cynthia_sas — Mon, 02 Jan 2017 17:53:52 GMT

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

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

aarony — Mon, 02 Jan 2017 17:55:06 GMT

Hi Cynthia. They are date variables.
Thanks for your reply.

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

Cynthia_sas — Mon, 02 Jan 2017 18:47:55 GMT

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