topic Re: round up every time in ODS and Base Reporting

round up every time

Abud — Fri, 11 May 2012 20:23:50 GMT

Hello everbody!!

Is there a SAS function to round a number up? The round() function

seems to round the number up or down depending on the rounding unit.

round(233, 100); ** will return 200;

round(250, 100); ** will return 300;

This is what I want:

round (233, 100); ** will return 300;

round (250, 100); ** will return 300;

tk's in advanced!

Re: round up every time

PGStats — Fri, 11 May 2012 21:02:06 GMT

%let unit=100;

* All you can do is :

data _null_;

up = &unit*CEIL(233/&unit);

down = &unit*FLOOR(255/&unit);

put down= up=;

run;

Re: round up every time

PGStats — Fri, 11 May 2012 21:20:23 GMT

Or you can define your own...

proc fcmp outlib=sasuser.mysubs.math;
function upround(x, unit);
return (unit*CEIL(x/unit));
endsub;
function downround(x, unit);
return (unit*FLOOR(x/unit));
endsub;
run;

options cmplib=sasuser.mySubs;

data _null_;
up = upRound(233,100);
down = downRound(255,100);
put down= up=;
run;

Re: round up every time

Abud — Mon, 14 May 2012 11:44:51 GMT

tk's PG !