topic Re: adjust datetime variable with GMT offset in SAS Programming

adjust datetime variable with GMT offset

somebody — Fri, 27 Jul 2018 22:14:33 GMT

I have a date_time variable that is in B8601DZ35. format which I successfully separated to a date variable and a time variable. I have another variable that contains the GMT offset. I would like to adjust my date_time variable for this GMT offset.How would I go about this?

Date-Time	                GMT Offset
2017-01-11T14:30:04.365434911Z  -5
2017-01-11T14:30:26.597592398Z	-5
2017-01-11T14:44:08.071375241Z	-5
2017-01-11T17:26:08.197434809Z	-5
2017-01-11T13:00:05.983270062Z	-5
2017-01-11T13:51:43.118027494Z	-5
2017-01-11T14:30:04.346793673Z	-5
2017-01-11T14:50:36.791404253Z	-5
2017-01-11T14:50:46.555107131Z	-5
2017-01-11T15:05:32.194165072Z	-5
2017-01-11T15:05:32.258194133Z	-5
2017-01-11T15:05:32.258194133Z	-5
2017-01-11T15:05:32.258194133Z	-5
2017-01-11T15:05:48.638213623Z	-5
2017-01-11T15:05:49.242262429Z	-5
2017-01-11T15:05:49.242262429Z	-5
2017-01-11T15:05:52.334463850Z	-5
2017-01-11T15:05:52.718504205Z	-5

here is an example of the data. Thanks

Re: adjust datetime variable with GMT offset

bobpep212 — Fri, 27 Jul 2018 22:29:44 GMT

As long as you have a datetime variable in a dt SAS format, you should be able to use the intnx function to shift the stamp by the value in GMT_Offset:

new_dt=intnx('hour',date_time,GMT_Offset,'s')

Edit: I typed intck and meant intnx - duh.

Re: adjust datetime variable with GMT offset

somebody — Sat, 28 Jul 2018 04:36:46 GMT

Thanks. I worked it out this way too. Just a quick question. How can I get millisecond from a time variable ?

Re: adjust datetime variable with GMT offset

ballardw — Mon, 30 Jul 2018 16:05:26 GMT

You can get the decimal portion of seconds of a datetime in a data step as:

decimal = datetime - floor(datetime);

since datetimes are stored as seconds.

Depending on which part of the value you want and how you want it multiplication, division and or round, floor or ceil functions may come into play.