topic Re: Is there a DATETIME FORMAT like YYYY-MM-DDThh:mm:ss ? in SAS Programming

Is there a DATETIME FORMAT like YYYY-MM-DDThh:mm:ss ?

Hugo_B — Mon, 20 May 2019 08:55:41 GMT

Hello,

Do you know if it exists a DATETIME format such like YYYY-MM-DDThh:mm:ss (note the 'T' between time and date),

and if not how to create this format with functions.

Thank you,

Regards,

Hugo_B.

Re: Is there a DATETIME FORMAT like YYYY-MM-DDThh:mm:ss ?

PeterClemmensen — Mon, 20 May 2019 09:00:23 GMT

proc format;
picture dtpic
other='%Y-%0m-%0dT%0H:%0M:%0S' (datatype=datetime);
run;

data test;
   datetime='25dec2000 00:00:00'dt;
   format datetime dtpic.;
run;

Re: Is there a DATETIME FORMAT like YYYY-MM-DDThh:mm:ss ?

Kurt_Bremser — Mon, 20 May 2019 09:04:24 GMT

There is (see Maxim 8 🙂 ).

It is E8601DT19.

29         data _null_;
30         now = datetime();
31         format now e8601dt19.;
32         put now=;
33         run;

now=2019-05-20T11:03:22