topic Need help in time format in SAS Programming

Need help in time format

apxprdtr10 — Tue, 08 May 2018 15:24:49 GMT

Hi all,

I have time format 515 and i want desired time format as 05:15.

could anybody help me with getting the desired format.

PeterClemmensen — Tue, 08 May 2018 15:50:24 GMT

Is time a character or numeric variable?

Either way, do something like this

data have;
   Time=515;
   CharTime=put(Time, 4.);
   RightTime=input(put(Time, 4.), hhmmss5.);
   format RightTime time5.;
run;

ballardw — Tue, 08 May 2018 15:52:02 GMT

Assuming your existing variable is actually numeric here is an example:

data junk;
   x=515;
   x=input(put(x,z4.),hhmmss.);
   format x time5.;
run;

apxprdtr10 — Mon, 14 May 2018 16:04:11 GMT

I really appreciate your valuable reply but it just slightly differ from my desired result.

your replied answer gives me time as 5:15 but i want as 05:15

art297 — Mon, 14 May 2018 16:17:53 GMT

You could always just roll your own format. e.g.:

proc format; 
   picture todx other='%0H:%0M' (datatype=time);
run;

data junk;
   x=515;
   x=input(put(x,z4.),hhmmss.);
   format x todx.;
run;

Art, CEO, AnalystFinder.com