Book Image

Hands-On SAS for Data Analysis

By : Harish Gulati
Book Image

Hands-On SAS for Data Analysis

By: Harish Gulati

Overview of this book

SAS is one of the leading enterprise tools in the world today when it comes to data management and analysis. It enables the fast and easy processing of data and helps you gain valuable business insights for effective decision-making. This book will serve as a comprehensive guide that will prepare you for the SAS certification exam. After a quick overview of the SAS architecture and components, the book will take you through the different approaches to importing and reading data from different sources using SAS. You will then cover SAS Base and 4GL, understanding data management and analysis, along with exploring SAS functions for data manipulation and transformation. Next, you'll discover SQL procedures and get up to speed on creating and validating queries. In the concluding chapters, you'll learn all about data visualization, right from creating bar charts and sample geographic maps through to assigning patterns and formats. In addition to this, the book will focus on macro programming and its advanced aspects. By the end of this book, you will be well versed in SAS programming and have the skills you need to easily handle and manage your data-related problems in SAS.
Table of Contents (17 chapters)
Free Chapter
1
Section 1: SAS Basics
4
Section 2: Merging, Optimizing, and Descriptive Statistics
7
Section 3: Advanced Programming
10
Section 4: SQL in SAS
13
Section 5: Data Visualization and Reporting

What this book covers

Chapter 1, Introduction to SAS Programming, introduces programming concepts and instills in you the confidence to write basic SAS programs. We will explore what happens behind the scenes in SAS and thereby ensure that the fundamentals are in place to learn advanced concepts in the book.

Chapter 2, Data Manipulation and Transformation, includes comprehensive coverage of data manipulation, including tasks such as numeric-to-character conversion, handling missing values and blanks, and logic and control functions.

Chapter 3, Combining, Indexing, Encryption, and Compression Techniques Simplified, will focus on understanding the pros and cons of various data table combination techniques. We will explore the pros and cons of techniques using examples and look under the hood to see how SAS processes code.

Chapter 4, Power of Statistics, Reporting, Transforming Procedures, and Functions, looks at built-in SAS procedures that help reduce the coding effort required on your part and provide you with the ability to transform data, produce statistics, run statistical tests, and produce reports.

Chapter 5, Advanced Programming Techniques – SAS Macros, focuses on understanding the concept of loops and SAS macros. This chapter will help you move to advanced programming within SAS.

Chapter 6, Powerful Functions, Options, and Automatic Variables Simplified, focuses on mastering SAS macros using system options and functions that help debug and optimize code.

Chapter 7, Advanced Programming Techniques Using PROC SQL, is all about the PROC SQL procedure. We will start by understanding basic concepts such as Cartesian joins, then explore the pros and cons of using DATA steps over PROC SQL. Using various examples, we will perform multiple data tasks using PROC SQL.

Chapter 8, Deep Dive into PROC SQL, will introduce the unique benefits of combining our understanding of PROC SQL with macros.

Chapter 9, Data Visualization, covers data visualization, which is vital in the world of big data, where visual analysis is key to understanding the insights that are generated from data reporting and data mining. We will look at why visualization is important and how we can produce charts in SAS to help deliver the value that data has to offer effectively.

Chapter 10, Reporting and Output Delivery System, focuses on the packaging and production of data reports and insights in multiple formats and platforms.