topic How to round up a date to nearest second in SAS Procedures

How to round up a date to nearest second

eagles_dare13 — Thu, 10 Jul 2014 18:44:53 GMT

What function can I use to change:

2014-07-09 11:42:34:826 -->

2014-07-09 11:42:35:000

i.e round the millisecond to the nearest second and put 000 in the millisecond portion. I need to use the rounded value in a join condition.

Reeza — Thu, 10 Jul 2014 19:20:18 GMT

I think the milliseconds come from the decimal point so try rounding to the nearest digit

round(time, 1)

JasonAllen — Thu, 10 Jul 2014 20:36:36 GMT

Hello eagles_dare13,

If your input data is consistently the same length (23 characters) and formatted as your example data, maybe try:

data have;

infile datalines delimiter=',';

format

dt $23.;

input dt;

datalines;

2014-07-09 11:42:34:826

;

run;

data want;

set have;

format

dt2 e8601dt23.3;

substr(dt,20,1)='.';

put dt=;

dt2=input(dt,e8601dt23.3);

dt2=ceil(dt2);

put dt2=;

run;