Functions and CALL Routines |
Returns the smallest integer that is greater than or equal to
the argument, fuzzed to avoid unexpected floating-point results.
-
argument
-
specifies a numeric constant, variable,
or expression.
If the argument is within 1E-12 of an
integer, the function returns that integer.
Unlike the CEILZ function, the CEIL function
fuzzes the result. If the argument is within 1E-12 of an integer, the CEIL
function fuzzes the result to be equal to that integer. The CEILZ function
does not fuzz the result. Therefore, with the CEILZ function you might get
unexpected results.
The following SAS statements produce these results.
SAS Statements |
Results |
var1=2.1;
a=ceil(var1);
put a;
|
3
|
b=ceil(-2.4);
put b;
|
-2
|
c=ceil(1+1.e-11);
put c;
|
2
|
d=ceil(-1+1.e-11);
put d;
|
0
|
e=ceil(1+1.e-13);
put e;
|
1
|
f=ceil(223.456);
put f;
|
224
|
g=ceil(763);
put g;
|
763
|
h=ceil(-223.456);
put h;
|
-223
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.