DATA Step, Macro, Functions and more

Reg : Time Part Rouding the mill sec

Reply
Contributor
Posts: 37

Reg : Time Part Rouding the mill sec

2012-07-11 09:43:20.55

i have used time part

it was rouging the sec based on milli seconds

i wnat the output to be

Time

------

09:43:20

Super Contributor
Posts: 349

Re: Reg : Time Part Rouding the mill sec

Respected Advisor
Posts: 3,799

Re: Reg : Time Part Rouding the mill sec

Why not use the

INT function and discard the offensive decimal part.

data _null_;

   input dt anydtdtm25.;

   put (dt)(=datetime20.2);

   nomill = int(dt);

   put (nomill dt)(=datetime.);

   cards;

2012-07-11 09:43:20.55

;;;;

   run;

799  data _null_;

800     input dt anydtdtm25.;

801     put (dt)(=datetime20.2);

802     nomill = int(dt);

803     put (nomill dt)(=datetime.);

804     cards;

dt=11JUL12:09:43:20.55

nomill=11JUL12:09:43:20 dt=11JUL12:09:43:21

Ask a Question
Discussion stats
  • 2 replies
  • 164 views
  • 0 likes
  • 3 in conversation