See if this works for you
data test;
date='20120304';
time='09:30:00';
datetime=dhms(input(date, yymmdd8.), 0, 0, input(time, time8.));
format datetime is8601dt.;
run;
Are date and time numerical values? I.e. actual date/time values or character values?
See if this works for you
data test;
date='20120304';
time='09:30:00';
datetime=dhms(input(date, yymmdd8.), 0, 0, input(time, time8.));
format datetime is8601dt.;
run;
Anytime 🙂
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.