Number manipulation

Various databases store numbers differently. While producing reports, the format of the number might need to be changed.

CEIL, FLOOR, INT, and ROUND

While we have focused a lot on string-based functions in this chapter, there are also multiple instances when some form of treatment needs to be applied to numeric variables. The troika of ceiling, flooring, and rounding functions are the basic functions that come in handy. While some experienced SAS users may find these functions to be too basic to justify spending time practicing them, by the end of this section, you will have discovered some common mistakes that can only be avoided by the proper use of these functions.

We will use all four functions in the...