topic Re: Issues with Date time in Statistical Procedures

Issues with Date time

r3570 — Fri, 28 May 2021 10:06:31 GMT

Hi Team,

I have a date column which is in character format as below:

Start Date

2020-02-02T16:29:00

2020-11-03

-----T12:47:00

I would like to convert into numeric format as well as the complete date as below:

Start Date

2020-02-02T16:29:00

2020-11-03T00:00:00

2020-01-01T12:47:00

Can anyone help ?

Re: Issues with Date time

yabwon — Fri, 28 May 2021 10:26:37 GMT

Something like this:

data want;
input Start_Date $ 20.;

t1 = scan(Start_Date,1,"T");
t2 = scan(Start_Date,2,"T");

Start_Date = catx("T",
ifc(t1 = "-----","2020-01-01",t1),
coalescec(t2,"00:00:00")
)
;
drop t:;
cards;
2020-02-02T16:29:00
2020-11-03
-----T12:47:00
;
run;
proc print;
run;

Bart