combine date +time into one field

[Ronein]

Hello

In my data set there are 2 columns:  date  and time.

In order to calculate column date_time I am using the following code:

dhms(date, 0, 0, time )as  date_time

However,In some rows I get bad results and the date_time field has no correct value,

Date column with informat date9. and format date9.

Time column with format time5.  and informat is null

[japelin]

What exactly is the value of "bad results"?

I think your code will give you the datetime value without any problem.

data have;
  date='08sep2022'd;time='12:57't;output;
  date='14sep2022'd;time='8:15't;output;
  format date date9. time time5. ;
run;

data want;
  set have;
  date_time =dhms(date, 0, 0, time );
  format date_time datetime16.;
run;
proc print;run;

proc sql;
  select have.*, dhms(date, 0, 0, time )as date_time format=datetime16. from have;
quit;

[Ronein]

Please look at this row of data.

Here the result that I get is wrong

[japelin]

Can the code for the entire step, not just the dhms function part, be timed as much as possible?

[Oligolas · Accepted solution]

Hi,

I'd say check your data, your SQL and your Log.

data demo;
date = '08SEP2022'd;
time = '12:57't;

date_time = dhms(date, 0, 0, time);

format date_time datetime20. date date9. time time5.;
run;

proc print data=demo;
run;

[PeterClemmensen]

Your posted code looks good to me.