topic Re: Combining two strings into a datetime variable in New SAS User

Combining two strings into a datetime variable

Ihsan-Mahdi — Thu, 20 Oct 2022 16:16:10 GMT

Hello,

I have two string variables in my set that I'm trying to combine into one datetime variable formatted DATETIEM20. I tried different codes and none of them worked. Help please!

refdisdate	refdistime
3/22/2019	17:26
4/25/2019	4:38
7/27/2019	18:31
7/29/2019	15:52
8/21/2019	22:24
10/3/2019	0:13
4/9/2019	10:37
12/20/2019	16:30
8/3/2019	17:45
11/25/2019	17:45

Re: Combining two strings into a datetime variable

PaigeMiller — Thu, 20 Oct 2022 16:37:01 GMT

UNTESTED CODE

date=input(refdisdate,mmddyy8.);
time=input(refdistime,time.);
datetime_variable = dhms(date),hour(time),min(time),0);

Re: Combining two strings into a datetime variable

Ihsan-Mahdi — Thu, 20 Oct 2022 16:59:05 GMT

Worked like a charm! Thank you 🙂