topic Re: Date and Time convert to DateTime in SAS Programming

Date and Time convert to DateTime

zimcom — Fri, 13 Sep 2019 18:49:40 GMT

Hi all,

I have a sig_Date variable of type YYMMDD10. and a sig_Time variable type TIME5.

sig_Date 2018-09-10

sig_Time 11:22

I want to combine them into 1 variable called sig_DateTime like 2018-09-10 00:11:22 using function

sig_DateTime = dhms(sig_Date,0,0,0)+ sig_Time;
format sig_DateTime is8601da.;

what I got is something like **********

Can someone tell me where I am wrong and I have been using this function for all the data and time to DateTime conversion, it all works well until this one

Thanks as always

Re: Date and Time convert to DateTime

novinosrin — Fri, 13 Sep 2019 19:09:24 GMT

Is this acceptable?

data w;
sig_Date='10sep2018'd;
sig_Time='11:22't;
sig_DateTime = dhms(sig_Date,0,0,0)+ sig_Time;
format sig_Date date9. sig_Time time5. sig_DateTime e8601dt25.;
run;

Re: Date and Time convert to DateTime

zimcom — Fri, 13 Sep 2019 19:22:22 GMT

can I convert it to datetime20. instead of e8601dt25.?

Re: Date and Time convert to DateTime

novinosrin — Fri, 13 Sep 2019 19:25:55 GMT

Hi @zimcom You are not converting anything here per se. A format doesn't change the value , it only changes how the value is displayed.

So change the format to whatever you want

data w;
sig_Date='10sep2018'd;
sig_Time='11:22't;
sig_DateTime = dhms(sig_Date,0,0,0)+ sig_Time;
format sig_Date date9. sig_Time time5. sig_DateTime datetime20.;
run;

Re: Date and Time convert to DateTime

zimcom — Fri, 13 Sep 2019 19:29:14 GMT

@novinosrin Thank you so much, it works now.

It did not previously.

THANK YOU SO MUCH!!!