Advanced SQL with SAS

Contents

Preface

About This Book

What Is SAS, for Me?

Acknowledgments

Acknowledgments for the 2012 Edition

About This Book

What Does This Book Cover?

Is This Book for You?

What Should You Know about the Examples?

Software Used to Develop the Book’s Content

Example Code and Data

SAS OnDemand for Academics

We Want to Hear from You

Author Feedback

About The Author

Chapter 1: Overview

1.1 Detailed Description of This Book

1.2 Which SAS Language for the CAS Environment?

Chapter 2: Missing Values

2.1 From the Start: Defining Missing Values

2.1.1 Missing Values in Numeric Variables

2.1.2 Missing Values in String Variables

2.1.3 Example: Test Data for Handling Missing Values

2.1.4 Defining Missing Entries when Creating Empty Tables

2.1.5 SQL Approach: ...