topic Re: format date/time in SAS Programming

format date/time

radhikaa4 — Mon, 16 Dec 2019 18:28:05 GMT

Current table

subjectid	start date	starttime
1	23-Nov-19	1213
2	24-Nov-19	1914

Need to combine date and time into one

subjectid	start date	starttime	start_date_time
1	23-Nov-19	1213	11/23/19 12:13
2	24-Nov-19	1914	11/24/19 19:14

I tried to concatenate but it is not a good approach

Re: format date/time

PaigeMiller — Mon, 16 Dec 2019 18:41:24 GMT

Please tell us if the variable start_date is a numeric or character variable.

Please tell us if the variable starttime is a numeric or character variable.

Re: format date/time

radhikaa4 — Mon, 16 Dec 2019 18:43:49 GMT

Start date is date9. And time is 50 character

Re: format date/time

PaigeMiller — Mon, 16 Dec 2019 18:56:41 GMT

So date is numeric, while time is character? So you would have to convert the character string time into hours and minutes as numbers, which is what this code does.

data want;
     set have;
     datetime=dhms(start_date,input(substr(time,1,2),2.),input(substr(time,3,2),2.),0);
     format datetime datetime16.;
run;