## converting numbers to time format?

Solved
Occasional Contributor
Posts: 13

# converting numbers to time format?

hello all,

in my question data set  i have a variable po_time as numbers and i want to create a new variable time in time format.

po_time       time

1253            12:53

116              13:16

143              12:43

238              14:38

there are lot of rows. i just want to convert to 24hr time format The variable po_time is in the numeric format.

thanks..

Accepted Solutions
Solution
‎10-30-2014 06:08 PM
Regular Contributor
Posts: 184

## Re: converting numbers to time format?

time = input(put(po_time,z4.),hhmmss4.) ;

format time time5. ;

All Replies
Regular Contributor
Posts: 180

## Re: converting numbers to time format?

Try this:

data have;
input po_time;
Cards;
1253
116
143
238
;
run;

data want (keep=po_time time);
set have;
h=int(po_time/100);
m=po_time-(h*100);
if h<12 then h=h+12;  /* Are you sure all times are in the afternoon?  */
time=hms(h,m,0);
format time time5.;
run;

CTorres

Solution
‎10-30-2014 06:08 PM
Regular Contributor
Posts: 184

## Re: converting numbers to time format?

time = input(put(po_time,z4.),hhmmss4.) ;

format time time5. ;

Contributor
Posts: 27

## Re: converting numbers to time format?

data have ;

input po_time ;

cards;

1253

1160

1430

2380

;

proc print;

run;

data want;

set have;

hms=hms(substr(left(po_time),1,2), substr(left(po_time), 3,2), 00);

format hms time8.;

run;

proc print;

run;

Occasional Contributor
Posts: 13

hi all,