Part 1
Using the SQL Procedure
Chapter 1
Introduction to the SQL Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Chapter 2
Retrieving Data from a Single Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Chapter 3
Retrieving Data from Multiple Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Chapter 4
Creating and Updating Tables and Views . . . . . . . . . . . . . . . . . . . . . . . . 111
Chapter 5
Programming with the SQL Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . 137
Chapter 6
Practical Problem-Solving with PROC SQL . . . . . . . . . . . . . . . . . . . . . . 177
1
2

Get SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition 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.