In this chapter, we presented some data problems and solved them using SAS functions. Some new topics such as LOOPS and BY GROUP processing were introduced to support the introduction of various functions. The functions that were dealt with in this chapter are primarily related to data quality and transformation. These are some of the basic tasks that an individual working with data is tasked to do. We also showcased how the same task can be completed using multiple functions. This was done to highlight how some functions can help streamline the process of writing efficient code.
In the next chapter, we will learn how to combine datasets and index, encrypt, and compress them.