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);
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.