topic Re: Reg : Time Part Rouding the mill sec in SAS Programming

Reg : Time Part Rouding the mill sec

My_SAS — Fri, 13 Jul 2012 11:58:04 GMT

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

shivas — Fri, 13 Jul 2012 12:06:54 GMT

check this..

Thanks,

Shiva

data_null__ — Fri, 13 Jul 2012 12:11:56 GMT

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