- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-13-2012 07:58 AM
(1214 views)
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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