topic Re: Get Time Zone Name or Time Zone ID Using UTC Offset in SAS Programming

Get Time Zone Name or Time Zone ID Using UTC Offset

UdayGuntupalli — Thu, 28 Feb 2019 19:44:17 GMT

All,
Is there a way to determine the current Time Zone Name or Time Zone ID using UTC offset ? For e.g.

Data Test; 
       UtcOffset = -7; 
Run;

I would like to retrieve enough information to be able to call tzones2u function i.e. timezone id .

Alternatively, even a macro based solution is fine if I have the following

%Let UtcOffset = -7;

Best

Uday

Re: Get Time Zone Name or Time Zone ID Using UTC Offset

ChrisNZ — Thu, 28 Feb 2019 20:39:49 GMT

I don't know of a built-in function.

If there none, you can easily build an informat from the pages Time Zone IDs and Time Zone Names

Re: Get Time Zone Name or Time Zone ID Using UTC Offset

UdayGuntupalli — Thu, 28 Feb 2019 21:53:21 GMT

@ChrisNZ ,
I am able to implement it in a different way :

data _null_;

start_date = datetime();

new_date1 = intnx("HOUR",start_date,-3);

format new_date1 datetime.;

put new_date1; 

run;

%Let t1 = %sysfunc(datetime()); 
%Let t2 = %sysfunc(intnx(hour,%sysfunc(datetime()),-3,same), datetime.);
%Put &t2;