character transform to date format

[harrylui]

Dear all,

encounter a difficult problem to me. is it possible to transform below character

2023-06-24 08:01:07.0

data example;
A='2023-06-24 08:01:07.0';
run;

to date format like this 24/6/2023 8:01:07 am?

thank in advance,

Harry

[HarrySnart]

data example;
informat B anydtdtm21.;
A='2023-06-24 08:01:07.0';
B = input(A,anydtdtm21.);
format B datetime.;
run;

 

Hope this helps

Harry

[Kurt_Bremser]

Try the E8601DT21. informat.