topic Time Zone conversion in SAS Procedures

Time Zone conversion

deleted_user — Tue, 18 Aug 2009 15:27:22 GMT

Is there a simple way to convert a timestamp in GMT to EDT? Any assistance would be greatly appreciated.

Re: Time Zone conversion

sbb — Tue, 18 Aug 2009 15:39:08 GMT

Explore using the INTNX function in a DATA step, based on the local-time (some identifying data value or general application rule).

Scott Barry
SBBWorks, Inc.

Re: Time Zone conversion

deleted_user — Tue, 18 Aug 2009 16:39:38 GMT

Thanks!!

Re: Time Zone conversion

Peter_C — Fri, 21 Aug 2009 12:50:39 GMT

rather than just subtracting 5hours (edt=gmt-'5:0:0't; ), have a look into the time-zone handling documentation at
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a003169814.htm

Also, in Formats-by-category, under "time formats", two formats look promising
E8601TMw.d Format
Writes time values using the ISO 8601 extended notation hh:mm:ss.ffffff.

E8601TZw.d Format
Adjusts time values to the Coordinated Universal Time (UTC) and writes them using the ISO 8601 extended notation hh:mm :ss+|-hh:mm.

PeterC