topic Re: Calculating elapsed time over a (spring or fall) time change in SAS Programming

Calculating elapsed time over a (spring or fall) time change

evp000 — Thu, 29 Sep 2016 15:17:45 GMT

HI,

I was wondering what your suggestions would be in calculating the actual elapsed time between two timepoints when a time change occurs between them. In the past I've done this manually:

- calculate the difference (in hours) using the start datetime and end datetime.

-if the start point was prior to the time change and the end point was after the time change, add or subtract 1 hour (depending on whether it's spring or fall).

Would INTCK('hour',startdatetime, enddatetime) somehow be able to take the time change into consideration? I realize this is location-specific.

Thanks for your input.

Re: Calculating elapsed time over a (spring or fall) time change

Shmuel — Thu, 29 Sep 2016 15:40:00 GMT

The arguments need for INTCK are not enough.

To calculate elapse hours is depnedet also on place, i.e. COUNTRY and sometime even REGION/STATE.

In some countries the change dates are dynamic according to political decisions, which make it even more complicate.

Re: Calculating elapsed time over a (spring or fall) time change

evp000 — Thu, 29 Sep 2016 18:54:21 GMT

Ok, thanks.