Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Kirk Paul Lafler
PROC SQL: Beyond the Basics Using SAS®
Copyright
Dedication
Preface
How This Book Is Organized
Reference Aids
Acknowledgments
Designing Database Tables
Introduction
Database Design
Column Names and Reserved Words
Data Integrity
Database Tables Used in This Book
Table Contents
Summary
Working with Data in PROC SQL
Introduction
Data Types Overview
SQL Operators and Functions
Dictionary Tables
Summary
Formatting Output
Introduction
Formatting Output
Formatting Output with the Output Delivery System
Summary
Coding PROC SQL Logic
Introduction
Conditional Logic
CASE Expressions
Interfacing PROC SQL with the Macro Language
Summary
Creating, Populating, and Deleting Tables
Introduction
Creating Tables
Populating Tables
Integrity Constraints
Deleting Rows in a Table
Deleting Tables
Summary
Modifying and Updating Tables and Indexes
Introduction
Indexes
Updating Data in a Table
Summary
Introduction
Introducing Complex Queries
Joins
Cartesian Product Joins
Inner Joins
Outer Joins
Subqueries
Set Operations
Summary
Working with Views
Introduction
Views — Windows to Your Data
Eliminating Redundancy
Restricting Data Access — Security
Hiding Logic Complexities
Nesting Views
Updatable Views
Deleting Views
Summary
Troubleshooting and Debugging
Introduction
The World of Bugs
The Debugging Process
Types of Problems
Troubleshooting and Debugging Techniques
Undocumented PROC SQL Options
Summary
Tuning for Performance and Efficiency
Introduction
Understanding Performance Tuning
Sorting and Performance
Splitting Tables
Indexes and Performance
Reviewing CONTENTS Output and System Messages
Optimizing WHERE Clause Processing with Indexes
Summary
Glossary
References
Call your local SAS office to order these books from Books by Users Press
JMP® Books
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
Preface
Dedication
To my mother, father, and brother for your love, support, and encouragement.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset