Getting Started with the SQL Procedure, First Edition
Contents
Credits
Chapter 1 Introduction to the SQL Procedure
- What Is the SQL Procedure?
- Terminology
- Tables for Examples
Chapter 2 Querying A Table
- Introduction
- Selecting Data Columns
- Sorting Data
- Summarizing Data
- Grouping Data
- Subsetting Data
- Validating the Query
- Specifying the Table to Query
- Working with Two Query Results
- Controlling tbe PROC SQL Step
Chapter 3 Creating and Updating SQL Procedure Tables
- Creating Tables
- Inserting Rows into Tables
- Updating Data Values in a Table
- Deleting Rows
- Altering Columns
- Indexing a Column
- Deleting a Table
- Using SQL Procedure Tables in Other SAS Procedures
Chapter 4 Creating and Using SQL Procedure Views
- How Are Views Useful?
- Creating Views
- Describing a View
- Deleting a View
- Tips for Using SQL Procedure Views
- Using SQL Procedure Views in Other SAS Procedures
Chapter 5 Joining Tables
- Introduction
- Inner Joins
- Multicolumn Joins
- Outer Joins
- Comparing DATA Step Match-Merges with SQL Procedure Joins
Chapter 6 Subqueries
- Simple Subqueries
- Correlated Subqueries
- Multiple Subqueries
- When to Use Joins and Subqueries
Chapter 7 Dictionary Tables
Chapter 8 The SQL Query Window
- Introduction
- Querying One Table
- Joining Two Tables
- Querying External Databases in the SQL Query Window
Index