CEILZ Function

Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.

Category: Truncation

Syntax

CEILZ (argument)

Required Argument

argument

is a numeric constant, variable, or expression.

Details

Unlike the CEIL function, the CEILZ function uses zero fuzzing. 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
a=ceilz(2.1);
put a;
3
b=ceilz(-2.4);
put b;
 
−2
c=ceilz(1+1.e-11);
put c;
 
2
d=ceilz(-1+1.e-11);
put d;
 
0
e=ceilz(1+1.e-13);
put e;
 
2
f=ceilz(223.456);
put f;
 
224
g=ceilz(763);
put g;
 
763
h=ceilz(-223.456);
put h;
 
-223