topic Convert UTC datetime to EST datetime in SAS Programming

Convert UTC datetime to EST datetime

Amine_Khemiri — Tue, 10 Sep 2019 12:10:27 GMT

Hello,

Could anyone help me to convert SAS UTC datetime to EST datetime?

Thanks for your help.

kind regards,

Amine

Example:

2011/01/03 01:03:00
2011/01/03 01:04:00

ChrisNZ — Wed, 11 Sep 2019 03:11:50 GMT

1. Like this?

data _null_;
  X='2011/01/03 01:03:00';
  format UTC EST datetime.;
  UTC=input(X,anydtdtm.);
  EST=intnx('hour',UTC,-5,'s');
  put UTC= EST=;
run;

UTC=03JAN11:01:03:00 EST=02JAN11:20:03:00

2. Maybe you don't need to transform anything at all. Look at the TIMEZONE option.