topic Re: COMBINING DATE AND TIME in SAS Programming

COMBINING DATE AND TIME

robertrao — Thu, 25 Jul 2024 12:09:14 GMT

Hello,

I have two seperate fields for date and time. I want to combine them to use for sorting purposes.

The time begins with SQLs start date as shown (01JAN1900) in the time coloumn.

SQL_DATE MILITARY_TIME Identifier WANT (datetime)

11DEC2021:00:00:00 01JAN1900:16:56:00:000 ID1 11DEC2021:16:56:00

11DEC2021:00:00:00 01JAN1900:23:46:00:000 ID1 11DEC2021:24:36:00

Thank you

Re: COMBINING DATE AND TIME

PaigeMiller — Thu, 25 Jul 2024 12:17:47 GMT

datetime=dhms(datepart(sql_date),hour(timepart(military_time)),minute(timepart(military_time)),0);

Alternative:

datetime2=sql_date+(military_time-'01JAN1900:00:00:00'dt);

Re: COMBINING DATE AND TIME

Tom — Thu, 25 Jul 2024 12:40:49 GMT

Use the DHMS() function. Pass the DATE from the one DATETIME value as the DAYS argument and the TIME from the other DATETIME value as the SECONDS value.

want=dhms(datepart(SQL_DATE),0,0,timepart(MILITARY_TIME));

Make sure to attach a datetime type format to the new WANT variable so the values print in the way humans will recognize as datetime values.