Calculating actual days between two datetime

[chuie]

Hi All,

I am struggling in  calculation actual length of stay which is given by days in between arrival date/time and discharge date time. I want to incorporate the time  also  as opposed to just calculating  days.

So for example  arrival datetime = 01/01/2019 7am  and discharge date time = 01/03/2019 9pm

so the actual length of stay should be 2 days and 14 hours 

I cannot upload the data due to privacy reason but attached  is the data set screenshot.

Thank you so much in advance

best,

C

[PeterClemmensen]

So how do you want the length of stay to be displayed in your desired data set? As a decimal number or as '2 days and 14 hours' or?

[chuie]

As a decimal like 12 hours if 3.5 days? or any standard format of actual LOS . I am not sure. My plan is to calculate the variance between GMLOS and Actual LOS . 

[PaigeMiller]

data want;
    set have;
    delta_time=new_admit-new_dis;
    days = floor(delta_time/86400);
    hours = floor((delta_time-days*86400)/3600);
    minutes = floor((delta_time-days*86400-hours*3600)/60);
run;

[Astounding]

DateTimes make this easy:

number_of_seconds = new_dis - new_admit;

If you want to convert that to hours, divide by 3600.

It should be relatively easy to convert number of hours into any form that you would like.

[PeterClemmensen]

data test;
arrival='01jan2019 07:00:00'dt;
discharge='03jan2019 21:00:00'dt;

time=discharge-arrival;

format arrival discharge datetime20.;
run;

[chuie]

YOU guys are AWESOME ... 

Thank you 🙂

one more question:

How to calculate "average patient per hour"

I have patients account number  and  admit date/time for entire 2018 year 

[PeterClemmensen]

Show us what your data looks like for a usable code answer

[chuie]

 I have  encounter number , admit date and admit hour for entire 2018 data ( n = 55000) where each row represents the  unique patient encounter.  I need to calculate the average patient per hour .

[mkeintz]

There is an alternative (or perhaps call it an extension) to dividing by number of seconds, minutes, hours, etc - namely a format that displays something like

     20D:12:30

which means 20 days, 12 hours, 30 minutes

proc format;
  picture fdur 
   low-high=  '%jD%0H:%0M' (datatype=datetime);
run;

data want;
  set have;
  duration=discharge-arrival;
  format duration fdur.;
run;

Caveats:

1. This works only up to 366 days of duration.
2. If you want seconds as well as hours and minutes, then the picture statement should be:   

      picture fdur

        low-high= '%jD%0H:%0M:%0S' (datatype=datetime);