topic Re: How to combine text date field and number time field into one datetime field in SAS Programming

How to combine text date field and number time field into one datetime field

zimcom — Sat, 14 Jul 2018 18:41:11 GMT

Dear community,

I have a read in date and time field as below

XNDAT	XNTIM
Jun 7 2015 12:00AM	17:53:00

of which XNDAT is 'Text ' and XNTIM as 'Num'

How can I combine them into a long SAS datetime

Your help is greatly appreciated and thank you

new SAS learner

zimcom

Re: How to combine text date field and number time field into one datetime field

novinosrin — Sat, 14 Jul 2018 19:04:23 GMT

data w;
k='Jun 7 2015 12:00AM';
k1='17:53:00't;
k2=input(k,anydtdte20.);
k3=dhms(k2,0,0,0)+k1;
format  k3 datetime20.;
run;

Re: How to combine text date field and number time field into one datetime field

zimcom — Sat, 14 Jul 2018 19:15:29 GMT

It works perfect, you are the best!

Thank you so much!!

zimcom

Re: How to combine text date field and number time field into one datetime field

zimcom — Sat, 14 Jul 2018 19:30:10 GMT

one more quetion, how to deal with these data below, combine then into one SAS long date?

XTDAT	XTTIM
Jun 7 2015 12:00AM	1/1/0001 6:15:00 PM

Thank you!

Re: How to combine text date field and number time field into one datetime field

novinosrin — Sat, 14 Jul 2018 19:35:30 GMT

data w;
k='Jun 7 2015 12:00AM';
k1='1/1/0001 6:15:00 PM';
k2=input(k,anydtdte20.);
k3=input(k1,anydtdtm21.);
k4=dhms(k2,0,0,0)+timepart(k3);
format k2 date9. k3 k4 datetime20.;
run;

Re: How to combine text date field and number time field into one datetime field

novinosrin — Sat, 14 Jul 2018 19:41:20 GMT

slight correction to the above:

data w;
k='Jun 7 2015 12:00AM';
k1='1/1/0001 6:15:00 PM';
k2=input(k,anydtdtm21.);
k3=input(k1,anydtdtm21.);
k4=k2+timepart(k3);
format k2 date9. k3 k4 datetime20.;
run;

Re: How to combine text date field and number time field into one datetime field

zimcom — Sat, 14 Jul 2018 19:44:49 GMT

you are absolutely awesome and helpful!!