Chapter 1: Overview

This book is written for advanced users in PROC SQL. The handling of missing values (null values) in PROC SQL is an important topic since SAS SQL handles missing values differently from the ANSI standard. Failure to take these features into account can lead to potentially undesirable results when dealing with missing values. Other topics in this book include data quality, especially with integrity constraints, as well as special features in dealing with missing values and visual analysis of geodata and distances.

Three chapters in this book are particularly important as they help you to harness the power of SAS. The chapter on macro programming, for example, describes how the listwise execution of commands can speed up work ...

Get Advanced SQL with SAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.