topic Re: converting numbers to time format? in SAS Programming

converting numbers to time format?

koushik — Thu, 30 Oct 2014 18:42:43 GMT

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.

please suggest. thanks in advance.

thanks..

Re: converting numbers to time format?

CTorres — Thu, 30 Oct 2014 19:35:06 GMT

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

Re: converting numbers to time format?

Howles — Thu, 30 Oct 2014 22:08:12 GMT

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

format time time5. ;

Re: converting numbers to time format?

bharathtuppad — Fri, 31 Oct 2014 03:30:33 GMT

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;

Re: converting numbers to time format?

koushik — Fri, 31 Oct 2014 12:06:12 GMT

hi all,

thanks for your support. all the answers are very helpful. gained knowledge. thanks for your time.

koushik