Combining date and time

[sasuser123123]

Hello!!
I've a date which is in character value is 20110423 and time 0015(character)
Now I'm trying to concatenate these two variables but error is coming
Could you please tell me how to get the new variable which consists date and time in datetime format

Thank you!!

[novinosrin]

Hi @sasuser123123 

data want;
d="20110423";
d1=input(d,yymmdd10.);
t="0015";
t1=input(substr(t,1,2)||':'||substr(t,3),hhmmss.);
datetime=dhms(d1,0,0,0)+t1;
format datetime datetime20.;
drop d1 t1;
run;

[Tom · Accepted solution]

The B8601DT informat should be able to do that. Just stick the letter T between the data and time strings.

data test;
  date='20110423';
  time='0015';
  datetime=input(catx('T',date,time),b8601dt.);
  format datetime datetime20.;
run;

[sasuser123123]

It's perfectly working. Thank you so much for your assistance
And could you please explain a little about B8601DT informat why we use that informat here.

Thank you.!