Text field Date and time convert to DataTime

[zimcom]

Hi all,

I have a date and time fields, both are Text data type

C_Date looks like 18/06/19  (YY/MM/DD)

C_Time looks like 12:30:48

I need to convert the above 2 text fields into one DateTime field (datetime20.), like 19JUN2019:12:30:48

Thank you!!

[novinosrin · Accepted solution]

data test;
C_Date='18/06/19';
C_Time='12:30:48';
N_date=input(c_date, yymmdd8.);
N_time=input(c_time, time8.);
N_datetime=dhms(N_date,0,0,0)+N_time;
format N_datetime datetime20.;
run;

[ballardw]

In a data step this should work.

cdt = dhms(input(c_date,yymmdd8.),0,0,input(c_time,time8.));

format cdt datetime18.;