Get full access to SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition and 60K+ other titles, with free 10-day trial of O'Reilly.
There's also live online events, interactive content, certification prep materials, and more.
PROC SQL Basics
How PROC SQL Is Unique
Writing a PROC SQL Step
The SELECT Statement
Creating New Columns
Specifying the Table
Specifying Subsetting Criteria
Ordering by Multiple Columns
Querying Multiple Tables
Specifying Columns That Appear in Multiple Tables
Specifying Multiple Table Names
Specifying a Join Condition
Summarizing Groups of Data
Creating Output Tables
Points to Remember
Sometimes you need quick answers to questions about ...
Get SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.