SAS easily reads 24h-clock times, but has no provisions for reading times with no separator, so you need to transform the value.
Here are two examples of options you have, one uses a custom informat to do the transformation.
proc format;
invalue val2dtm 's/(.{10}) (\d\d)(\d\d)/\1:\2:\3/' (regexpe)=[anydtdtm.];
run;
data HAVE;
A='01/03/2011 0534';
B=input(A,val2dtm.);
putlog B= datetime20.;
run;
data HAVE;
A='01/03/2011 0534';
B=prxchange('s/(\d\d).(\d\d).(\d{4}).(\d\d)(\d\d)/\3-\1-\2T\4:\5/',1,A);
C=input(B,e8601dt.);;
putlog C= datetime20.;
run;
B=01MAR2011:05:03:00 C=03JAN2011:05:34:00
(My locale uses a default data format of dd/mm/yyyy, but the code above translates your date as mm/dd/yyyy since that's what you use)
... View more
