search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
Advanced Search
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS(R) 9.2 SQL Query Window User's Guide
PDF
|
Purchase
Contents
About
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
Index here
Product
Release
Base SAS
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
24Feb2009
Previous Page
|
Next Page
Previous Page
|
Next Page
SAS 9.2 SQL Query Window User's Guide
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
Previous Page
|
Next Page
|
Top of Page
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Previous Page
|
Next Page
|
Top of Page