Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 6. Truncation Functions > Functions That Round and Truncate Numerical V...
Functions That Round and Truncate Numerical Values
| Function: | CEIL |
|---|---|
| Purpose: | To round up to the next largest integer. |
| Syntax: | CEIL (numeric-value) |
| numeric-value is any SAS numeric variable, expression, or numerical constant. For negative arguments, the returned value is an integer between the number and zero (see the following examples). For positive arguments, the function returns just the integer portion of the number (the same as the INT function). Values within 10-12 of the value of an integer will return the integer. |
Examples
| Function | Returns |
|---|---|
| CEIL(1.2) | 2 |
| CEIL(1.8) | 2 |
| CEIL(-1.2) | -1 |
| CEIL(-1.8) | -1 |
