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);
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);
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.