topic Re: how to separate variable into date and time in SAS Programming

how to separate variable into date and time

EPANG1 — Sun, 21 Nov 2021 22:40:18 GMT

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

Re: how to separate variable into date and time

PaigeMiller — Sun, 21 Nov 2021 22:44:17 GMT

In a data step, assuming your variable is named DATE

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

Re: how to separate variable into date and time

sbxkoenk — Sun, 21 Nov 2021 22:44:58 GMT

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

Re: how to separate variable into date and time

EPANG1 — Sun, 21 Nov 2021 22:49:05 GMT

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

Re: how to separate variable into date and time

PaigeMiller — Sun, 21 Nov 2021 22:51:33 GMT

@EPANG1

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

Re: how to separate variable into date and time

sbxkoenk — Sun, 21 Nov 2021 22:55:22 GMT

Especially as it would be my 100th solution. 😉

No worries!

I guess @EPANG1 will do it correct next time.

Koen

Re: how to separate variable into date and time

EPANG1 — Sun, 21 Nov 2021 22:57:55 GMT

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.

Re: how to separate variable into date and time

sbxkoenk — Sun, 21 Nov 2021 23:04:18 GMT

Again, no worries!

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

My answer is definitely in the thread.

Koen