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

Copyright 2019 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Screenshots in this book are created with SAS University Edition software. Copyright 2014, SAS Institute Inc., Cary, NC, USA. All Rights Reserved. Reproduced with permission of SAS Institute Inc., Cary, NC

The modifiers of the SCAN function in this book are taken from SAS 9.2 Language Reference: Dictionary, Fourth Edition, Copyright 2011, SAS Institute Inc., USA. All Rights Reserved. Reproduced with permission of SAS Institute Inc, Cary, NC

Commissioning Editor: Amey Varangaonkar
Acquisition Editor: Yogesh Deokar
Content Development Editor: Athikho Sapuni Rishana
Senior Editor: Sofi Rogers
Technical Editor: Dinesh Chaudhary
Copy Editor: Safis Editing
Project Coordinator: Kirti Pisat
Proofreader: Safis Editing
Indexer: Pratik Shirodkar
Production Designer: Shraddha Falebhai

First published: September 2019

Production reference: 1260919

Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.

ISBN 978-1-78883-982-2

www.packt.com

Packt.com

Subscribe to our online digital library for full access to over 7,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.

• Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals

• Improve your learning with Skill Plans built especially for you

• Get a free eBook or video every month

• Fully searchable for easy access to vital information

• Copy and paste, print, and bookmark content

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.packt.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at customercare@packtpub.com for more details.

At www.packt.com , you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.

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.

Harshil Gandhi is part of SAS India's Consulting team. As a consultant, he provides consulting and implementation services, including requirements gathering, analysis, solution development/implementation, and knowledge transfer. He also assists sales teams with relevant activities and ensures the highest levels of customer satisfaction. Harshil is good at rapidly prototyping solutions thanks to his background in data science (MTech). He is also a visiting scholar at NMIMS Mumbai.

If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.

SAS is one of the leading enterprise tools in the world today in the fields of data management and analysis. It enables faster, easier processing of data and empowers you to get valuable business insights for effective decision-making.

This book will serve as an all-encompassing, comprehensive guide that you can refer to while preparing for your SAS certification exam. After a quick walk-through of the SAS architecture and components, this book teaches you the different ways to import and read data from different sources using SAS. You will become familiar with SAS Base, the 4GL programming language, and SQL procedures, with comprehensive coverage of topics such as data management and data analysis. You will then move on to learn about the advanced aspects of macro-programming .

By the end of this book, you will be an expert in SAS programming and will be able to handle and manage your data-related problems in SAS with ease.

If you are a data professional who's new to SAS programming and wants to be an expert at it, this is the book for you. Those looking to prepare for the SAS certification exam will also find this book to be a very handy resource. Some understanding of basic data management concepts will help you get the most out of this book.

, 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.

, 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.

, 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.