• 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


ProductRelease
Base SAS9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011