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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.