topic Re: How to convert UTC date time value to different timezone like PST, CST EST in SAS Programming

How to convert UTC date time value to different timezone like PST, CST EST

anandbillava — Tue, 15 Mar 2011 19:15:07 GMT

Can somebody let me know how do we convert the UTC date time to other timezone values.

Is there any SAS functiion for this ?

Re: How to convert UTC date time value to different timezone like PST, CST EST

sbb — Tue, 15 Mar 2011 20:52:27 GMT

Use the INTNX function to adjust a DATETIME type SAS variable after inputting it. Also, you may find prior posts on these forums, as well as SAS-hosted DOC and supplemental technical / conference reference material (suggesting website SEARCH or using Google advanced search below).

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

utc datetime values intnx function site:sas.com

Re: How to convert UTC date time value to different timezone like PST, CST EST

chang_y_chung_hotmail_com — Tue, 15 Mar 2011 21:21:20 GMT

If you have a datetime value in UTC, just subtract 5 hours to get EST:

   data _null_;

     utc = '15mar2011 21:15:21'dt;

     est = utc - 5*60*60;

     format utc est datetime.;

     put (_all_) (/=);

   run;

   /* on log

   utc=15MAR11:21:15:21

   est=15MAR11:16:15:21

   */

Re: How to convert UTC date time value to different timezone like PST, CST EST

anandbillava — Tue, 15 Mar 2011 21:43:47 GMT

I have done similar program. But I am asking is there a function which does it autromatically... by taking locale as a input parameter.

Re: How to convert UTC date time value to different timezone like PST, CST EST

sbb — Tue, 15 Mar 2011 23:03:42 GMT

Locale, as in some GMT offset somewhere out in the operating system enviroment?

Not likely - check the DOC and consider using INTNX with your adjustment as argument #3.

Scott Barry
SBBWorks, Inc.

Re: How to convert UTC date time value to different timezone like PST, CST EST

chang_y_chung_hotmail_com — Wed, 16 Mar 2011 02:20:56 GMT

> ...is there
> a function which does it autromatically... by taking
> locale as a input parameter.

No, there isn't one among the built in.