** SAS read data with format: yyyy-mm-dd hh:mm:ss ****;
** SAS 9.13 Version ***;
data testdt(keep=datetp my_time date_time);
input datetp :$10. @12 my_time time8.;
my_year=input(substr(datetp,1,4),4.);
my_mon=input(substr(datetp,6,2),2.);
my_day=input(substr(datetp,9,2),2.);
my_date=mdy(my_mon,my_day,my_year);
format my_date MMDDYY10.;
date_time=DHMS(my_date,hour(my_time),minute(my_time),second(my_time));
format date_time datetime18.;
datalines;
1960-03-01 08:23:45
1960-01-01 18:23:58
1967-02-04 09:45:59
;
run;
proc print;
var my_time date_time;
format my_time time8. date_time datetime18.;
id datetp;
run;
|