Hands-On SAS for Data Analysis: A practical guide to performing effective queries, data visualization, and reporting techniques

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

1. Introduction to SAS Programming
2. Data Manipulation and Transformation
3. Combining, Indexing, Encryption and Compression Techniques Simplified
4. Power of Statistics, Reporting, Transforming Procedures and Functions
5. Advanced Programming Techniques: SAS Macros
6. Powerful Functions, Options and Automatic Variables Simplified
7. Advanced Programming Techniques using Proc SQL
8. Deep dive into PROC SQL
9. Data Visualization
10. Reporting and Output Delivery System

Harish Gulati is a consultant, analyst, modeler, and trainer based in London. He has 16 years of financial, consulting, and project management experience across leading banks, management consultancies, and media hubs. He enjoys demystifying his complex line of work in his spare time. This has led him to be an author and orator at analytical forums. His published books include SAS for Finance by Packt and Role of a Data Analyst, published by the British Chartered Institute of IT (BCS). He has an MBA in brand communications and a degree in psychology.