convert variable numeric time (hours,min) to character variable $7

michtka — Thu, 26 Jul 2012 18:10:06 GMT

Hi everyone, I am interesting to put the final numeric variable time I got, for example 176:30...in a character variable: 176:30 with format $7

Any help? Thnaks. V.

data have;

input hours 8.;

datalines;

176.5

1.25

2.5

;;;

run;

data want;

set have;

format time HHMM7.;

time = hours*3600;

run;

proc print; run;

Re: convert variable numeric time (hours,min) to character variable $7

art297 — Thu, 26 Jul 2012 18:30:37 GMT

One way would be:

data have;
input hours 8.;
datalines;
0
176.5
1.25
2.5
3
;

data want;
set have;
time = put(hours*3600,HHMM7.);
run;