topic convert eastern datetime to local datetime in SAS Programming

convert eastern datetime to local datetime

Beto16 — Fri, 13 May 2016 18:47:46 GMT

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.

Re: convert eastern datetime to local datetime

PGStats — Fri, 13 May 2016 21:45:32 GMT

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

Re: convert eastern datetime to local datetime

ballardw — Mon, 16 May 2016 16:36:36 GMT

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.