topic Re: Counting Dates Question in SAS Programming

Counting Dates Question

IgawaKei29 — Wed, 12 Apr 2017 11:13:51 GMT

So I have two sets of dates one is Start_Date the other Closed_Date. Start_Date is always populated, however Closed_Date can be null. I have a formula in Excel that does the job, but I wanted to migrate this into SAS.

Excel Formula: =IF(I5="", TODAY() - H5,I5-H5)

So what I am trying to do is if Closed_Date is null then take today's date and subtract the Start_Date which will give me days open. However if the Closed_Date has a value, subtract that value from the Start_Date to give me days open.

How would I transform this excel code into SAS code?

Re: Counting Dates Question

Astounding — Wed, 12 Apr 2017 11:33:41 GMT

Something like this in a DATA step should work:

if closed_date > . then days_open = closed_date - start_date;

else days _open = today() - start_date;

There are minor efficiency considerations that could avoid calling the TODAY() function so many times. But that would be way down the list of priorities.

Re: Counting Dates Question

IgawaKei29 — Wed, 12 Apr 2017 11:51:34 GMT

Thank you this is perfect. I had to play around with the dates a little, but once I did the count worked perfectly.

data work.test;
 set work.extract;
  format closed_date start_date date9.;
 
   closed_date=datepart(closed_date);
   start_date=datepart(start_date);


    if closed_date > . then days_open = closed_date - start_date;
    else days_open = today() - start_date;
run;