topic Re: Convert character time to numeric in SAS Programming

Convert character time to numeric

Takumi — Tue, 25 Feb 2014 13:12:35 GMT

This is the question:

Z is a character variable whose value takes the form "x hr y min" for different integers x and y. Create a numeric variable X5 storing the corresponding number of minutes. For example if Z is "2 hr 25 min", then X5 should be 145.

I have had problems when time was displayed with : (ex: 9:30:30) or AM/PM (9:30 AM), but I never encountered this kind. How do I approach such problem? T

Re: Convert character time to numeric

AncaTilea — Tue, 25 Feb 2014 13:34:08 GMT

Hi.

Here is one poorly written way:

data in;

Z = "2 hr 25 min";

hr = input(scan(z, 1,"hr"), 8.);

min = input(

tranwrd(

reverse(

scan(

reverse(z), 1,"rh")

"min",""),

8.);

/* "nim 52 rh 2"*/

/* 25 min*/

time_in_Min = hr*60+min;

run;

Re: Convert character time to numeric

Linlin — Tue, 25 Feb 2014 13:36:40 GMT

data have;

time='2 hr 25 min';

num=input(scan(time,1),2.)*60+input(scan(time,3),2.);

proc print;run;

Re: Convert character time to numeric

DBailey — Tue, 25 Feb 2014 13:53:06 GMT

data have;

input x txt1 $ y txt2 $;

z=x*60 + y;

cards;

2 hr 25 min

;

run;

Re: Convert character time to numeric

pradeepalankar — Tue, 25 Feb 2014 14:04:00 GMT

data have;

input time $50.;

if countw(time,': ')>=3 then

num=input(scan(time,1,': '),2.)*60+input(scan(time,3,': '),2.);

else

num=input(scan(time,1,': '),2.)*60+input(scan(time,2,': '),2.);

cards;

2 hr 25 min

1:30:30

9:30:30

9:30

00:12

1 hr 10 min

;

run;

output:

Obs time num

1 2 hr 25 min 145

2 1:30:30 90

3 9:30:30 570

4 9:30 570

5 00:12 12

6 1 hr 10 min 70

Re: Convert character time to numeric

Takumi — Tue, 25 Feb 2014 14:12:18 GMT

Thank :smileygrin:

Re: Convert character time to numeric

Takumi — Tue, 25 Feb 2014 14:12:26 GMT

Thanks :smileygrin:

Re: Convert character time to numeric

Takumi — Tue, 25 Feb 2014 14:12:32 GMT

Thanks :smileygrin:

Re: Convert character time to numeric

pradeepalankar — Tue, 25 Feb 2014 14:26:31 GMT

if you got ur answer then mark it as answered