Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing
Category: Truncation
CEILZ ( argument )
argument
is a numeric constant, variable, or expression.
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.
The following SAS statements produce these results.
SAS Statements | Results |
---|---|
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; | |
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 |
Functions:
'CEIL Function' on page 431
'FLOOR Function' on page 544
'FLOORZ Function' on page 546
'INT Function' on page 597
'INTZ Function' on page 609
'ROUND Function' on page 789
'ROUNDE Function' on page 796
'ROUNDZ Function' on page 797