topic Re: Calculating Difference in HH:MM:SS time using INTCK in SAS Procedures

Calculating Difference in HH:MM:SS time using INTCK

ebonyw — Tue, 24 Feb 2015 15:58:23 GMT

Hi! I am EXTREMELY wet behind the ears in SAS. I have data of medical providers and how long they recorded temperatures in their vaccine storage units. The amount of time that these providers were recording temperatures in their refrigerators and freezers is presented in a DATE/HH:MM format. I need to create a new variable (duration), that subtracts the End time from the Start time to determine the total time they were recording. The data in my new duration variable should be presented in HH:MM:SS format. I will need to manipulate the HH:MM:SS data in the duration column in different ways by provider, so I need SAS to continue to recognize it in this format and add them correctly.

Date/Time Start	Date/Time End	(New Variable) Duration
10/31/13 10:27	10/31/13 15:27	5:00:00
9/27/13 9:15	9/28/13 12:00	26:45:00
9/28/13 12:15	9/28/13 13:15	1:00:00
10/1/13 8:01	10/1/13 8:36	00:30:00
		Need to be able to add Duration correctly - 33:15:00

I found the following INTCK statements that seem as though they may be on the right track of giving me what I need, however, the statements split out the hours/minutes/seconds. It doesn't give me the duration in the hh:mm:ss format.

Datetime arguments:

hours=intck ('hour' , '01jan2009:00:00:00'dt, '01jan2010:00:00:00'dt);

minutes=intck ('minute' , '01jan2009:00:00:00'dt, '01jan2010:00:00:00'dt);

seconds=intck ('second', '01jan2009:00:00:00'dt, '01jan2010:00:00:00'dt);

The result values will be:

*hours = 8760

*minutes = 525600

*seconds = 31536000

Re: Calculating Difference in HH:MM:SS time using INTCK

PaigeMiller — Tue, 24 Feb 2015 16:07:33 GMT

If the values are true SAS datetime values, then the duration is simply the subtraction of the End minus Start times. This is the duration in seconds. INTCK is not needed.

If you want to present this number of seconds as HH:MM:SS, you could use the proper format, which is the TIMEw.d format

Re: Calculating Difference in HH:MM:SS time using INTCK

ebonyw — Tue, 24 Feb 2015 16:23:28 GMT

Thanks so much, Paige! I'm not sure if my values were true SAS datetime values. I will go look.

Re: Calculating Difference in HH:MM:SS time using INTCK

PaigeMiller — Tue, 24 Feb 2015 18:06:49 GMT

If they are not datetime values (for example they are characters), then you should convert them to datetime, that would be the easiest path forward.