topic combine numeric date and numeric time into a numeric datetime in SAS Programming

combine numeric date and numeric time into a numeric datetime

Nieves — Sat, 28 Jul 2018 10:26:02 GMT

Hi,

I have a numeric date variable date and numeric time variable time, if I combine them using the following code,

datetime = put(dhms(date,0,0,time),DATETIME.);

it returns a character datetime, for example, 01JAN18:00:01:00.

May I ask is there any method to combine into a numeric datetime ?

Thanks

PeterClemmensen — Sat, 28 Jul 2018 10:33:25 GMT

Do not use PUT Function and do like this

data have;
   format t time. dt date9. datetime datetime.;
   dt='01jan18'd;
   t='00:01't;

   datetime=dhms(dt,0,0,t);
run;

novinosrin — Sat, 28 Jul 2018 10:35:46 GMT

remove the put and keep it numeric just with dhms

Nieves — Sat, 28 Jul 2018 10:37:40 GMT

Thanks!