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;
... View more