Contents
About
Title Page
An Overview of the SQL Query Window
Introduction
Invoking the SQL Query Window
Query Window Menus
Examples
Setting Up the Environment
Performing Simple Queries
Sorting Your Output
Building Calculated Columns
Building and Adding Tables
Joining Matching Data
Saving Queries
Using Parentheses and Other Operators
Designing and Saving a Report
Creating Summary Reports
Counting and Grouping Data Automatically
Summarizing Groups of Data
Subsetting Groups of Data with the HAVING Condition
Using the Automatic Lookup Feature
Creating and Using Outer Joins
Customizing Your Session and Using Advanced Features
Setting Your Profile
Switching to Another Profile
Handling Missing Values
Defining a Format Outside the SQL Query Window
Changing Access Modes
Using SAS Data Sets to Store System Tables Information
Handling Embedded Blanks in Column Names
Including Saved Queries
Recommended Reading
Glossary
Product
Release
Base SAS
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011