BookmarkSubscribeRSS Feed
evp000
Quartz | Level 8

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.

2 REPLIES 2
Shmuel
Garnet | Level 18

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1889 views
  • 0 likes
  • 2 in conversation