BookmarkSubscribeRSS Feed
anandbillava
Fluorite | Level 6
Can somebody let me know how do we convert the UTC date time to other timezone values.

Is there any SAS functiion for this ?
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
chang_y_chung_hotmail_com
Obsidian | Level 7
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

   */
anandbillava
Fluorite | Level 6
I have done similar program. But I am asking is there a function which does it autromatically... by taking locale as a input parameter.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
chang_y_chung_hotmail_com
Obsidian | Level 7
> ...is there
> a function which does it autromatically... by taking
> locale as a input parameter.

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 8107 views
  • 0 likes
  • 3 in conversation