topic Re: How do I convert character time to numeric time? in SAS Programming

How do I convert character time to numeric time?

teja5959 — Wed, 18 Dec 2019 03:51:55 GMT

Data have character time

time

10:32

10:14

10:15

10:06

09:42

i want

10:32:00

10:14:00

10:15:00

10:06:00

09:42:00

Re: How do I convert character time to numeric time?

mkeintz — Wed, 18 Dec 2019 04:02:16 GMT

You would read a raw file (i.e. a text file with character values for time) with an INPUT statement, and a suitable INFORMAT for the variable. Analogously you can read a character variable to a numeric (time) variables with an INPUT function, and a suitable INFORMAT.

data have;
  input txt_time $5.;
datalines;
10:32
10:14
10:15
10:06
09:42
run;

data want;
  set have;
  num_time=input(txt_time,time5.0);
  format num_time time8.0;
  put num_time=;
run;

whilch display on the log

num_time=10:32:00
num_time=10:14:00
num_time=10:15:00
num_time=10:06:00
num_time=9:42:00

Re: How do I convert character time to numeric time?

novinosrin — Wed, 18 Dec 2019 04:02:29 GMT

data have;
input time $10.;
cards;
10:32
10:14
10:15
10:06
09:42
;

data want;
set have;
num_time=input(time,time.);
format num_time time8.;
run;

Re: How do I convert character time to numeric time?

Kurt_Bremser — Wed, 18 Dec 2019 11:07:55 GMT

You fix that when you read the data in the first place:

data have;
input time time5.;
format time time8.;
cards;
10:32
10:14
10:15
10:06
09:42
;

Re: How do I convert character time to numeric time?

DrAbhijeetSafai — Tue, 23 Aug 2022 07:05:55 GMT

Found it helpful!