convert eastern datetime to local datetime

[Beto16]

Hi I have a table that has the time set at eastern time I need it to be local time depending what time zone...
Here is example
STATE. START. END.
TX. 02/07/16 01:59 AM. 02/07/16 02:02 AM


I need that to convert to local texas time..... I can add zip code actually I have a column that has time off set which shows an -60.

[PGStats · Accepted solution]

You could use an informat to translate the state name into a minute offset :

proc format;
invalue timeZone
"TX" = -60
"NY" = 0
OTHER = 0
;
run;

data have;
infile datalines dsd dlm=".";
input STATE :timeZone. (START END) (:MDYAMPM.);
TX_start = intnx("MINUTE",START, STATE);
TX_end = intnx("MINUTE", END, STATE);
format TX_: dateampm.;
datalines;
TX. 02/07/16 01:59 AM. 02/07/16 02:02 AM.
;

[ballardw]

Is there any chance you're going to be dealing with Texas times in the El Paso region? El Paso is Mountain Time zone.

if you have the SAS supplied SASHELP.Zipcode data set (or download it) there is time offset and daylight savings time information by Zip code that may be of use.