Rounding in EG

[AaroninMN]

Is there a rounddown function in EG?
I'd like my data to be like this:
2.3 = 2
2.4 = 2
2.5 = 2
2.6 = 2
2.7 = 2
2.8 = 2
2.9 = 2
3.0 = 3

Any help would be appreciated.

Thanks!

[sbb]

The DATA step FLOOR or possibly the INT function.

Scott Barry
SBBWorks, Inc.

[AaroninMN]

Thanks Scott. The INT function worked.

[GenDemo]

Hi

I'm also looking into this at the moment. I am working with date and time stamps, and want to round down to the nearest minute - this means I would like round down a number to the nearest increment of 60.

Currently I am using round(floor(timepart(a.update_dt)/60)*60, 1) .

Does anyone have a difference/better solution?

[andreas_lds]

Using the intnx-function seems to be better:

data _null_;
   d = datetime();
   put d datetime.;
   r = intnx('dtminutes', d, 0, 'B');
   put r datetime.;
run;

[GenDemo]

Hahahaha, touché !