Previous Page | Next Page

Functions and CALL Routines

CEIL Function



Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floating-point results.
Category: Truncation

Syntax
Arguments
Details
Comparisons
Examples
See Also

Syntax

CEIL (argument)


Arguments

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.


Examples

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


See Also

Functions:

CEILZ Function

Previous Page | Next Page | Top of Page