topic Re: Rounding in EG in SAS Enterprise Guide

Rounding in EG

AaroninMN — Thu, 11 Sep 2008 18:11:55 GMT

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!

Re: Rounding in EG

sbb — Thu, 11 Sep 2008 18:29:37 GMT

The DATA step FLOOR or possibly the INT function.

Scott Barry
SBBWorks, Inc.

Re: Rounding in EG

AaroninMN — Thu, 11 Sep 2008 20:48:03 GMT

Thanks Scott. The INT function worked.

Re: Rounding in EG

GenDemo — Tue, 25 Sep 2018 05:00:57 GMT

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?

Re: Rounding in EG

andreas_lds — Tue, 25 Sep 2018 06:03:39 GMT

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;

Re: Rounding in EG

GenDemo — Wed, 26 Sep 2018 01:32:35 GMT

Hahahaha, touché !