Converting the time from HH:MM:SS to numeric

[kbrennan]

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.

[noling]

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

[kbrennan]

Yes.

[kbrennan]

Yes.

[Kurt_Bremser]

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

[kbrennan]

Thanks for the info.

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

[Kurt_Bremser]

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;

[noling]

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;