CEIL Function
Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floating-point results.
| Categories: | Truncation |
| CAS |
Syntax
CEIL(argument)
Required Argument
argument
specifies a numeric constant, variable, or expression.
Details
If the argument is within
1E-12 of an integer, the function returns that integer.
Comparisons
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.
Example
The following SAS statements
produce these results:
|
SAS Statement
|
Result
|
|---|---|
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 |
See Also
Functions:
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: March 16, 2017