topic Re: Converting the time from HH:MM:SS to numeric in SAS Programming

Converting the time from HH:MM:SS to numeric

kbrennan — Mon, 25 Mar 2019 14:18:21 GMT

I am trying to convert the time from a column called Start_Time to a number.

An example is (In Military Time) 6:24:43 to the number 6.

Once I get the number I want to put that number into a new Column called New_Time.

Re: Converting the time from HH:MM:SS to numeric

noling — Mon, 25 Mar 2019 14:27:07 GMT

Are you trying to pull the just the hour? There is an hour function.

Re: Converting the time from HH:MM:SS to numeric

Kurt_Bremser — Mon, 25 Mar 2019 14:27:34 GMT

data want;
start_time = '6:24:43';
new_time = input(start_time,time8.);
format new_time time8.;
run;

Re: Converting the time from HH:MM:SS to numeric

kbrennan — Mon, 25 Mar 2019 14:32:46 GMT

Thanks for the info.

How do use that column "start_time" instead of quantifying each one such as the 6:24:43 ?

Re: Converting the time from HH:MM:SS to numeric

kbrennan — Mon, 25 Mar 2019 14:34:17 GMT

Yes.

Re: Converting the time from HH:MM:SS to numeric

kbrennan — Mon, 25 Mar 2019 14:34:22 GMT

Yes.

Re: Converting the time from HH:MM:SS to numeric

Kurt_Bremser — Mon, 25 Mar 2019 14:35:10 GMT

To use an existing dataset, use the set statement:

/* make up some sample data */
data have;
input start_time :$8.;
cards;
6:24:43
;
run;

data want;
set have;
new_time = input(start_time,time8.);
format new_time time8.;
run;

Re: Converting the time from HH:MM:SS to numeric

noling — Mon, 25 Mar 2019 15:12:24 GMT

If you only want the hour and want to read from the existing data set, use KurtBremser's SET statement with the HOUR function:

/* make up some sample data */
data have;
input start_time :$8.;
cards;
6:24:43
23:11:11
01:40:30
;
run;

data want;
	set have;
	new_time = hour(input(start_time,time8.));
run;