using datetime18. format

alepage — Wed, 21 Oct 2020 15:57:26 GMT

Hello,

I have some difficulties with a date format in one of our old program:

data a;
x=1918425600;
y=x;
format x datetime18. ;
output;
x=MDY(1,1,1900);
y=x;
output;
run;

How can I get 01jan00:00:00:00 instead of 31DEC59:17:54:46

Regards,

Re: using datetime18. format

Kurt_Bremser — Wed, 21 Oct 2020 16:06:47 GMT

MDY results in a date value (count of days), to expand it to a datetime (count of seconds), use DHMS:

x = dhms(mdy(1,1,1900),0,0,0);