topic Re: How to convert DATETIME to ISO8601 format ? in SAS Programming

How to convert DATETIME to ISO8601 format ?

bobbyc — Fri, 09 Sep 2016 15:37:45 GMT

How do I convert 05AUG16:17:10:05 to 2016-08-05T17:10:05 ?

Thanks for your help.

Re: How to convert DATETIME to ISO8601 format ?

Michiel — Fri, 09 Sep 2016 15:49:17 GMT

data _NULL_;
format
dt datetime20.
dt2 E8601DT20.
;
dt=datetime();
dt2=dt;
put dt= dt2=;
txt=put(dt,datetime20.);
txt2=put(dt2,E8601DT20.);
put txt= txt2=;
run;

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm

Re: How to convert DATETIME to ISO8601 format ?

DrAbhijeetSafai — Tue, 17 Oct 2023 05:50:19 GMT

I found the reply helpful, but it is difficult to read the answer in current alignment. Hence, I am wring the same answer with proper alignment.

=================================================================================

data _NULL_;
format dt datetime20. dt2 E8601DT20. ;
dt=datetime();
dt2=dt;
put dt= dt2=;
txt=put(dt,datetime20.);
txt2=put(dt2,E8601DT20.);
put txt= txt2=;
run;

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm

================================================================================

Thanking you,

Yours sincerely,

- Dr. Abhijeet Safai