How to combine date and time

[sasuser123123]

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

[PeterClemmensen]

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

[sasuser123123]

Both date and time variables are in character format

[sasuser123123]

I mean character values

[PeterClemmensen · Accepted solution]

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;

[sasuser123123]

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

Thank you so much for your assistance.

[PeterClemmensen]

Anytime 🙂