Book Image

Big Data Analytics with SAS

Book Image

Big Data Analytics with SAS

Overview of this book

SAS has been recognized by Money Magazine and Payscale as one of the top business skills to learn in order to advance one’s career. Through innovative data management, analytics, and business intelligence software and services, SAS helps customers solve their business problems by allowing them to make better decisions faster. This book introduces the reader to the SAS and how they can use SAS to perform efficient analysis on any size data, including Big Data. The reader will learn how to prepare data for analysis, perform predictive, forecasting, and optimization analysis and then deploy or report on the results of these analyses. While performing the coding examples within this book the reader will learn how to use the web browser based SAS Studio and iPython Jupyter Notebook interfaces for working with SAS. Finally, the reader will learn how SAS’s architecture is engineered and designed to scale up and/or out and be combined with the open source offerings such as Hadoop, Python, and R. By the end of this book, you will be able to clearly understand how you can efficiently analyze Big Data using SAS.
Table of Contents (17 chapters)

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