Hi, have you already figured out? data have;
input date $ time $;
datalines;
20171102 0024
20171212 1124
20170708 1020
20170808 0030
;
run;
data want;
set have;
sdate=input(date,anydtdte12.);
stime=input(substr(time,1,2)||':'||substr(time,3,2),time6.);
stime_wrong=input(time,hhmmss6.);
dtime=dhms(sdate,0,0,stime);
format sdate date11. stime time6. stime_wrong time6. dtime datetime15. ;
run;
proc print noobs data=want; run;
... View more
