how to separate variable into date and time

[EPANG1]

Hi all,

Currently the variable is formated as datetime22.  like 01JAN2021:03:20:55. 

How can I get the time out of this field in the output below ?

03:20:55 

Thanks

[PaigeMiller]

In a data step, assuming your variable is named DATE

time=timepart(date);
format time time8.;

[sbxkoenk]

data _NULL_;
 a='01JAN2021:03:20:55'dt; put a= datetime22.;
 b=datepart(a)           ; put b= date9.;
 c=timepart(a)           ; put c= time8.;
run;
/* end of program */

Koen

[EPANG1 · Accepted solution]

Here is the solution. Thanks Koen.

Re: how to separate variable into date and time
data _NULL_;
a='01JAN2021:03:20:55'dt; put a= datetime22.;
b=datepart(a) ; put b= date9.;
c=timepart(a) ; put c= time8.;
run;
/* end of program */
Koen

[PaigeMiller]

@EPANG1 

You need to mark the solution from @sbxkoenk as correct, not your own post where you repeat his solution.

[sbxkoenk]

Especially as it would be my 100th solution. 😉

No worries!

I guess @EPANG1 will do it correct next time.

Koen

[EPANG1]

Apologies as I only see your answer in my inbox, but not displaying in the community forum. that's why I have copy the response again. 

[sbxkoenk]

Again, no worries!

Maybe you had to refresh / reload the browser page you were looking at (?).

My answer is definitely in the thread.

Koen