I have the date time format as '1/11/2017 8:00:41 AM +00:00' and it is in character format. I don't there this '+00:00' came from, but in my all data they all end with '+00:00', so I really don't care.
can someone help me convert it to Datetime format like '1/11/2017 8:00:41 AM' please?
DATA Have;
Date_Time='1/11/2017 8:00:41 AM +00:00';
RUN;
data w;
have='28-APR-20 02.56.42.897749 PM';
want=input(have, datetime30.);
format want datetime30.;
run;
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.