Vortex Tracker

Re: How many hours each month

Vortex — Tue, 19 May 2015 14:27:38 GMT

Hi thank you for your help Xia.

When I tried with checkin date time April 4, 2014 17:25 and checkout datetime April 30, 2014 23:59 the hours are a bit off.

Using the code above I got 635 hours.

I used this website to do the calculation and it came with 630 hours not sure what they meant by rounding down.

http://www.timeanddate.com/date/durationresult.html?m1=4&d1=4&y1=2014&m2=4&d2=30&y2=2014&h1=17&i1=25&s1=0&h2=23&i2=59&s2=59

Here is the timestamp but I don't think it should matter since the area and visit_number is the same.

Checkin Date/Time

Checkout Date/Time

4/4/2014 17:25	4/14/2014 11:08
4/14/2014 11:08	4/14/2014 11:10
4/14/2014 11:10	4/16/2014 10:44
4/16/2014 10:44	4/21/2014 8:12
4/21/2014 8:12	4/23/2014 14:35
4/23/2014 14:35	4/27/2014 16:47
4/27/2014 16:47	4/29/2014 21:38
4/29/2014 21:38	5/3/2014 0:15

How many hours each month

Vortex — Sun, 17 May 2015 05:22:31 GMT

I received a request where the customer wants me to show how many hours the patient stayed in each month.

Here is an example:Patient was here January 1st 2:00 pm and discharge February 2nd 1:00AM

Should become like this:

January: 730 hours (10 hours on January 1st + 30 days *24 hours per day)

February 25 hours (24 hours on February 1st and 1 hour on February 2nd).

If you cannot figure out a way, I would be greatly appreciated if you can at least provide me information how to calculate the number of hours patient stayed on first and last day (10 hours on January 1st and 1 hour on February 2nd). I have a way to calculate the hours between January 2nd and February 1st. I am having problems in getting the hours to midnight for first day and midnight to discharge datetime for the last day

I tried intck with 'end', 'b' but I keep getting error messages.

Here is sample of the checkin and checkout datetime

CheckinDate: 01JAN2014:2:00:00PM

CheckoutDate: 02FEB2014:1:00:00AM

THis is a followup after this post I have posted

This time the requester wants number of hours instead of number of days each month.

Re: Finding number of days each month between dates

Vortex — Thu, 30 Apr 2015 14:20:51 GMT

Hey RW9, I just tried and yes I can use it!

Thank you

Re: Finding number of days each month between dates

Vortex — Thu, 30 Apr 2015 14:10:14 GMT

Here are some sample data:

Visit Number Checkin Date CheckoutDate

2342	12/25/2014	1/6/2015
1234	12/27/2014	1/1/2015

Should be this:

Visit Number Checkin Date CheckoutDate Dec 2014 Jan 2015

2342	12/25/2014	1/6/2015	7	6
1234	12/27/2014	1/1/2015	5	1

Re: Finding number of days each month between dates

Vortex — Thu, 30 Apr 2015 13:42:26 GMT

Sorry the link didn't show up:

https://communities.sas.com/thread/51733

I am trying to find another code that does similar to this. The issue with this it does not work for cross year boundaries i.e December 2014 and January 2015

Finding number of days each month between dates

Vortex — Thu, 30 Apr 2015 13:31:25 GMT

Hi I am looking for a code that does the feature by JP in this thread. The issue is that if the year of the start and end date is different it does not work.

Example, Dec 2, 2014 and ends January 3, 2015.

Thank you

Re: Building an array of days in months, based off two dates

Vortex — Thu, 30 Apr 2015 13:29:47 GMT

Hi I was wondering if there is code that does similar to the code Astounding provided but it can cross year boundaries such as December 13, 2014 to January 12, 2015.

Thank you

Re: How to convert character datetime to numeric datetime?

Vortex — Tue, 15 Jul 2014 14:48:10 GMT

Hi Thank you. I tried your's but the day and the month got switched.

Re: How to convert character datetime to numeric datetime?

Vortex — Tue, 15 Jul 2014 14:47:35 GMT

Hey thank you the one by user24feb works.

How to convert character datetime to numeric datetime?

Vortex — Mon, 14 Jul 2014 02:24:20 GMT

I have a file in Excel that I use to import the data into SAS.
The format of the data in the Excel is this:
28-05-2014 10:21:20
27-05-2014 14:22:26
27-05-2014 11:36:33
27-05-2014 17:14:55
27-05-2014 10:34:56
27-05-2014 19:03:48
27-05-2014 14:30:56
In SAS, the type is text, length is 19 and format is $19.
I am using this column to admission date which looks like this 08JUL2013:08:22:00. Therefore I would like to convert the above datetime to this format 28MAY2014:10:21:20 or 28MAY2014:10:21:00
Please let me know what I should do?
THank you