topic Re: combine date +time into one field in SAS Programming

combine date +time into one field

Ronein — Thu, 15 Sep 2022 07:53:42 GMT

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

Re: combine date +time into one field

japelin — Thu, 15 Sep 2022 07:46:59 GMT

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;

Re: combine date +time into one field

Oligolas — Thu, 15 Sep 2022 07:51:57 GMT

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;

Re: combine date +time into one field

Ronein — Thu, 15 Sep 2022 07:52:46 GMT

Please look at this row of data.

Here the result that I get is wrong

Re: combine date +time into one field

PeterClemmensen — Thu, 15 Sep 2022 07:55:18 GMT

Your posted code looks good to me.

Re: combine date +time into one field

japelin — Thu, 15 Sep 2022 07:57:28 GMT

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