topic How to combine date and time in SAS Data Management

How to combine date and time

sasuser123123 — Mon, 21 Oct 2019 06:15:41 GMT

Hello!
I've date 20120304 and time 09:30:00
I need to combine these two dates with is8601dt. format.

I'm using the below code.
Data new;
Set old;
NewDate=put(input(catch('T',date,time),b8601dt.),is8601dt.);
run;

While I'm running this code I got a error which shows invalid argument to input function

Could you please solve this query..

Thank you.
Regards

Re: How to combine date and time

PeterClemmensen — Mon, 21 Oct 2019 06:17:41 GMT

Are date and time numerical values? I.e. actual date/time values or character values?

Re: How to combine date and time

sasuser123123 — Mon, 21 Oct 2019 06:20:14 GMT

Both date and time variables are in character format

Re: How to combine date and time

sasuser123123 — Mon, 21 Oct 2019 06:21:40 GMT

I mean character values

Re: How to combine date and time

PeterClemmensen — Mon, 21 Oct 2019 06:32:44 GMT

See if this works for you

data test;
    date='20120304';
    time='09:30:00';
    datetime=dhms(input(date, yymmdd8.), 0, 0, input(time, time8.));
    format datetime is8601dt.;
run;

Re: How to combine date and time

sasuser123123 — Mon, 21 Oct 2019 06:39:34 GMT

@PeterClemmensen
Thank you so much. It's perfectly working.

Thank you so much for your assistance.

Re: How to combine date and time

PeterClemmensen — Mon, 21 Oct 2019 06:40:45 GMT

Anytime 🙂