PROC SQL: Beyond the Basics Using SAS®

PROC SQL: Beyond the Basics Using SAS®

by Kirk Paul Lafler
Released September 2004
Publisher(s): SAS Institute
ISBN: 9781590475348

Read it now on the O’Reilly learning platform with a 10-day free trial.

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

Start your free trial

Book description

Master the language of PROC SQL! Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) guidelines and non-ANSI features. A broad range of SAS users, including applications programmers, database designers and administrators, statisticians, and systems analysts, will find techniques in Kirk Lafler's PROC SQL: Beyond the Basics Using SAS to enhance their data access, manipulation, and presentation prowess. Topics examined include database design; an introduction to SQL, dictionary tables, and tables; coding PROC SQL logic as well as complex queries; working with views; troubleshooting and debugging SQL code; and tuning for performance. With the growing popularity of databases, PROC SQL is becoming the language of choice for SAS users around the world. Intermediate and advanced users will appreciate the straightforward explanations and numerous examples.

Table of contents

  1. Copyright
    1. Dedication
  2. Preface
    1. How This Book Is Organized
    2. Reference Aids
  3. Acknowledgments
  4. Designing Database Tables
    1. Introduction
    2. Database Design
    3. Column Names and Reserved Words
    4. Data Integrity
    5. Database Tables Used in This Book
    6. Table Contents
    7. Summary
  5. Working with Data in PROC SQL
    1. Introduction
    2. Data Types Overview
    3. SQL Operators and Functions
    4. Dictionary Tables
    5. Summary
  6. Formatting Output
    1. Introduction
    2. Formatting Output
    3. Formatting Output with the Output Delivery System
    4. Summary
  7. Coding PROC SQL Logic
    1. Introduction
    2. Conditional Logic
    3. CASE Expressions
    4. Interfacing PROC SQL with the Macro Language
    5. Summary
  8. Creating, Populating, and Deleting Tables
    1. Introduction
    2. Creating Tables
    3. Populating Tables
    4. Integrity Constraints
    5. Deleting Rows in a Table
    6. Deleting Tables
    7. Summary
  9. Modifying and Updating Tables and Indexes
    1. Introduction
    2. Modifying Tables
    3. Indexes
    4. Updating Data in a Table
    5. Summary
  10. Coding Complex Queries
    1. Introduction
    2. Introducing Complex Queries
    3. Joins
    4. Cartesian Product Joins
    5. Inner Joins
    6. Outer Joins
    7. Subqueries
    8. Set Operations
    9. Summary
  11. Working with Views
    1. Introduction
    2. Views — Windows to Your Data
    3. Eliminating Redundancy
    4. Restricting Data Access — Security
    5. Hiding Logic Complexities
    6. Nesting Views
    7. Updatable Views
    8. Deleting Views
    9. Summary
  12. Troubleshooting and Debugging
    1. Introduction
    2. The World of Bugs
    3. The Debugging Process
    4. Types of Problems
    5. Troubleshooting and Debugging Techniques
    6. Undocumented PROC SQL Options
    7. Summary
  13. Tuning for Performance and Efficiency
    1. Introduction
    2. Understanding Performance Tuning
    3. Sorting and Performance
    4. Splitting Tables
    5. Indexes and Performance
    6. Reviewing CONTENTS Output and System Messages
    7. Optimizing WHERE Clause Processing with Indexes
    8. Summary
  14. Glossary
  15. References
  16. Call your local SAS office to order these books from Books by Users Press
    1. JMP® Books
  17. Index

Product information

  • Title: PROC SQL: Beyond the Basics Using SAS®
  • Author(s): Kirk Paul Lafler
  • Release date: September 2004
  • Publisher(s): SAS Institute
  • ISBN: 9781590475348