Browse Prior Art Database

SAS SQL Ouery Window User's Guide

IP.com Disclosure Number: IPCOM000243387D
Original Publication Date: 1999-Dec-31
Included in the Prior Art Database: 2015-Sep-19
Document File: 118 page(s) / 1M

Publishing Venue

SAS Institute Inc.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 5% of the total text.

Page 01 of 118

SAS ®SQL Query Window User's Guide

Version 8



Page 02 of 118

The correct bibliographic citation for this manual is as follows: SAS Institute Inc., SAS SQL Query Window User's Guide, Version 8, Cary, NC: SAS Institute Inc., 1999. pp. 118.

SAS SQL Query Window User's Guide, Version 8

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA.

ISBN 1-58025-554-X
All rights reserved. Printed in the United States of America. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc.


U.S. Government Restricted Rights Notice. Use, duplication, or disclosure of the software by the government is subject to restrictions as set forth in FAR 52.227-19 Commercial Computer Software-Restricted Rights (June 1987).

SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.
1st printing, October 1999
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries.® indicates USA registration.

DB2®, DB/2

TM

, DB2/6000

                                 are registered trademarks or trademarks of International Business Machines Corporation. ORACLE® is a registered trademark or trademark of Oracle Corporation. ® indicates USA registration.

Other brand and product names are registered trademarks or trademarks of their respective companies.

The Institute is a private company devoted to the support and further development of its software and related services.

TM

TM

, OS/2®, and SQL/DS


Page 03 of 118


4 An Overview of the SQL Query Window 1

Introduction 1

Invoking the SQL Query Window 2

Query Window Menus 3

Chapter 2

4 Examples 9

The First Steps 10

Sorting Your Output 22

Building Calculated Columns 25

Building and Adding Tables 29

Joining Matching Data 30

Saving Queries 32

Using Parentheses and Other Operators 35

Designing and Saving a Report 38

Creating Summary Reports 44

Counting and Grouping Data Automatically 46

Summarizing Groups of Data 52

Subsetting Groups of Data with the Having Condition 56

Using the Automatic Lookup Feature 58

Creating and Using Outer Joins 66

Chapter 3

      4 Customizing Your Session and Using Advanced Features 73 Setting Your Profile 73

Switching to Another Profile 83

Handling Missing Values 83

Defining a Format Outside the SQL Query Window 84

Changing Access Modes 87

Using SAS Data Sets to Store System Tables Information 89

Embedded Blanks in Column Names 90

Including Saved Queries 90

Chapter 4

      4 Using the SQL Query Window in SAS/AF Applications 93 SAS/AF Classes for the SQL Query Window 94

SCL Class Method Examples 100

Index 107

Contents

Chapter 1



Page 04 of 118

iv


Page 05 of 118

1

1

C H A P T E R

An Overview of the SQL Query Window

Introduction 1
Invoking the SQL Query Window 2 Query Window Menus 3

File PMENU 3

Save Query 3
List/Include Saved Queries... 4 Create Table from Query Re...