topic Re: Combining date and time in SAS Data Management

Combining date and time

sasuser123123 — Wed, 18 Sep 2019 16:50:43 GMT

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!!

Re: Combining date and time

novinosrin — Wed, 18 Sep 2019 17:04:05 GMT

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;

Re: Combining date and time

Tom — Wed, 18 Sep 2019 17:57:01 GMT

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;

Re: Combining date and time

sasuser123123 — Thu, 19 Sep 2019 05:23:32 GMT

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.!