topic Text field Date and time convert to DataTime in SAS Programming

Text field Date and time convert to DataTime

zimcom — Fri, 13 Sep 2019 19:04:25 GMT

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!!

Re: Text field Date and time convert to DataTime

novinosrin — Fri, 13 Sep 2019 19:14:11 GMT

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;

Re: Text field Date and time convert to DataTime

ballardw — Fri, 13 Sep 2019 19:15:21 GMT

In a data step this should work.

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

format cdt datetime18.;