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,
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);
View solution in original post
It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.
Submit your proposal →
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!