topic Re: Need to find timezone in SAS Procedures

Need to find timezone

Gil_ — Thu, 15 Feb 2018 06:54:11 GMT

I have a table thst has
City state zip lat long
I need to find the time zone base of these col for example
Central...

Thanks for assistance

Re: Need to find timezone

PeterClemmensen — Thu, 15 Feb 2018 09:47:05 GMT

I don't think SAS has such a functionality directly, but below is a link to a data base that links latitude and longitude to time zones

https://boutell.com/zipcodes/

Re: Need to find timezone

ballardw — Thu, 15 Feb 2018 17:00:52 GMT

You may actually have a dataset installed named SASHELP.ZIPCODE which has that information including city names (and some alternate names as well), state zipcode and lat and long though those may not match.

The question may be are your zips 5 or 5+4?

The ZIP in sashelp.zipcode is numeric so matching may require adjusting values.

Assuming your zip are numeric and of the classic 5 number variety:

proc sql;
   create table tz as
   select a.*, b.timezone, b.gmtoffset
   from youdata as a
       left join
       sashelp.zipcode as b
       on a.zip=b.zip;
quit;

If you zip is a 5 character with leading 00 as needed then

proc sql;
   create table tz as
   select  a.*, b.timezone, b.gmtoffset
   from youdata as a
       left join
       sashelp.zipcode as b
       on a.zip= put(b.zip,z5.);
quit;