DATA Step, Macro, Functions and more

combine numeric date and numeric time into a numeric datetime

Reply
Contributor
Posts: 22

combine numeric date and numeric time into a numeric datetime

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 

PROC Star
Posts: 1,400

Re: combine numeric date and numeric time into a numeric datetime

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;
Contributor
Posts: 22

Re: combine numeric date and numeric time into a numeric datetime

Thanks!

Super User
Posts: 2,037

Re: combine numeric date and numeric time into a numeric datetime

remove the put and keep it numeric just with dhms

Ask a Question
Discussion stats
  • 3 replies
  • 77 views
  • 2 likes
  • 3 in conversation