topic character transform to date format in SAS Programming

character transform to date format

harrylui — Tue, 25 Jul 2023 09:23:09 GMT

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 — Tue, 25 Jul 2023 11:13:02 GMT

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 — Tue, 25 Jul 2023 17:41:05 GMT

Try the E8601DT21. informat.