topic Re: concatenating two separate fields (date and time) into one datetime field in ODS and Base Reporting

concatenating two separate fields (date and time) into one datetime field

DianeAnna — Thu, 24 Jul 2014 14:40:58 GMT

I have two separate fields - one a date and one a time - that I need to concatenate together into one long datetime field.

Date field is a numeric field, currently in the YYYY-MM-DD format (2014-07-24 for example) and the time field is numeric in the HH:MM:SS format (9:23:00 or 11:35:00 for example - the leading 0 is not there for half of the time).

I need to get these two separate fields into a format that looks like: 01NOV13:09:23:00 - the date has a length of 7, the time has a length of 8 and there is a colon between them.

I tried formatting both fields, then concatenating, then formatting the concatenated field, and no such luck.

Thanks!

Re: concatenating two separate fields (date and time) into one datetime field

RW9 — Thu, 24 Jul 2014 14:51:07 GMT

Hi,

attrib newdate format=datetime15.;

newdate=input(put(date,date7.)||put(time,hhmmss.),datetime.);

Re: concatenating two separate fields (date and time) into one datetime field

DianeAnna — Thu, 24 Jul 2014 15:01:56 GMT

Great - that worked, except that SAS couldn't find the hhmmss format - I changed it to hhmm8. and then it worked like a charm.

I didn't even think about the attrib - have rarely used it.

Thanks!

Re: concatenating two separate fields (date and time) into one datetime field

Haikuo — Thu, 24 Jul 2014 15:02:16 GMT

Since your date and time are numeric, another option is to use DHMS function.

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

Haikuo