Hands-On SAS for Data Analysis

A practical guide to performing effective queries, data visualization, and reporting techniques

Harish Gulati

• Publisher: Packt Publishing
• Year: 2019
• Print ISBN: 9781788839822
• eBook ISBN: 9781788836104
• Edition: 1
• Topic: Computer Science
• Subtopic: Artificial Intelligence (AI) & Semantics
• Index: Computer Science

Leverage the full potential of SAS to get unique, actionable insights from your data

Key Features

• Build enterprise-class data solutions using SAS and become well-versed in SAS programming
• Work with different data structures, and run SQL queries to manipulate your data
• Explore essential concepts and techniques with practical examples to confidently pass the SAS certification exam

Book Description

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.

What you will learn

• Explore a variety of SAS modules and packages for efficient data analysis
• Use SAS 4GL functions to manipulate, merge, sort, and transform data
• Gain useful insights into advanced PROC SQL options in SAS to interact with data
• Get to grips with SAS Macro and define your own macros to share data
• Discover the different graphical libraries to shape and visualize data with
• Apply the SAS Output Delivery System to prepare detailed reports

Who this book is for

Budding or experienced data professionals who want to get started with SAS will benefit from this book. Those looking to prepare for the SAS certification exam will also find this book to be a useful resource. Some understanding of basic data management concepts will help you get the most out of this book.

Table of contents

• Title Page
• Copyright and Credits
• About Packt
• Contributors
• Preface
• Section 1: SAS Basics
• Introduction to SAS Programming
• Data Manipulation and Transformation
• Section 2: Merging, Optimizing, and Descriptive Statistics
• Combining, Indexing, Encryption, and Compression Techniques Simplified
• Power of Statistics, Reporting, Transforming Procedures, and Functions
• Section 3: Advanced Programming
• Advanced Programming Techniques - SAS Macros
• Powerful Functions, Options, and Automatic Variables Simplified
• Section 4: SQL in SAS
• Advanced Programming Techniques Using PROC SQL
• Deep Dive into PROC SQL
• Section 5: Data Visualization and Reporting
• Data Visualization
• Reporting and Output Delivery System
• Other Books You May Enjoy