Chapter 3. Data Preparation Using SAS Data Step and SAS Procedures

As was discussed in Chapter 2, Working with Data Using SAS® Software, data needs to be prepared in a format that allows certain analytics to actually be able to run and process efficiently.

In this chapter, we will cover the following topics:

  • Creating indicators for the first and last observation in a by group 
  • Transposing the rows and columns in a table
  • Statistical and mathematical data transformations
  • SAS macro facility

Data preparation for analytics

 SAS has been dealing with for over 41 years and specifically preparing data to be analyzed using analytics. There are certain features of the data step language, as well as certain PROCs, that save a programmer's time and effort in ...

Get Big Data Analytics with SAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.