Hope below query solve your problem data abc; input datetime $23.; datalines; 19/07/2018 09:34:02 AM 18/07/2018 09:19:50 PM 13/07/2018 06:28:39 PM 12/07/2018 09:58:06 AM 12/07/2018 08:54:34 AM run; data test; set abc; date_new=input(scan(datetime,1,''),ddmmyy10.); format date_new ddmmyy10.; run;
... View more