Hi All,
My data has a date column and time column.
I would like to create a column datetime with format yyyy-mm-dd hh:mm:ss.ms and export to csv.
Clearly, my time doesn't has millisecond and 00000 is fine.
Can you please help me to get the code?
Thanks,
HHC
data have;
input date time;
informat time time11.;
format date date9. time time11.;
datalines;
20130730 4:00:00
20130130 5:15:00
run;
proc format;
picture mydt (default=24)
low-high='%Y-%0m-%0d %0H:%0M:%0S.0000' (datatype=datetime)
;
run;
data have;
input date time;
informat date yymmdd10. time time11.;
format date date9. time time11.;
datalines;
20130730 4:00:00
20130130 5:15:00
run;
data want; set have;
dt = dhms(date,0,0,time);
format dt mydt.;
run;
... View more
