How to convert numeric data to hour:minute

[proximo20]

Hi,

My data looks like this

time code
1300 ert
1412 brt
1435 grt

and I need it like this

13:00 ert
14:12 brt

or

1:00 ert
2:12 ...

Thanks

 

[dblan]

I'm not a time expert, but here is my best effort.

/*sample dataset*/
data unformatted;
input time code $3.;
datalines;
1300 ert
1412 brt
1435 grt
;
run;

data formatted;
set unformatted;
newtime = put(time,$4.);
format realtime hhmm5.;
realtime = hms(substr(newtime,1,2),substr(newtime,3,2),00);
run;

DBLAN

 

[proximo20]

Thanks DBLAN, it works.