topic Re: merge "date" and "time" as a variable "date and time" in SAS Procedures

merge "date" and "time" as a variable "date and time"

Ken_oy — Tue, 21 Sep 2010 20:09:26 GMT

I have a variable "date" and a "time" for each patient.
I want to merge them to one variable "date and time"， is any way I can do that?

Thanks! Message was edited by: Ken_oy

Re: merge "date" and "time" as a variable "date and time"

data_null__ — Tue, 21 Sep 2010 20:21:07 GMT

Are they SAS dates and times?

If so then you just need to convert them to the proper units and add them together.

[pre]datetime = dhms(date,0,0,time);[/pre]

Is commonly used.

Re: merge "date" and "time" as a variable "date and time"

Ken_oy — Tue, 21 Sep 2010 20:47:28 GMT

Thanks for your quick reply.

I test the code from you, it works for SAS date and SAS time.

But my problem is, I have character variables instead, all strings

i.g.: "date"="01/01/2007"; "time"="13:00:00"

How to transfer all these strings into a SAS date9. format? thanks!

Re: merge "date" and "time" as a variable "date and time"

Ken_oy — Tue, 21 Sep 2010 21:28:36 GMT

OK, for now I fixed it with your help.

1. transfer those strings into a SAS date:

sas_date=input(substr(string_date, 1, 10), mmddyy10.);

2. using data_null_'s code:

it works now!

Thanks!