SAS SQL Ouery Window User's Guide
Original Publication Date: 1999-Dec-31
Included in the Prior Art Database: 2015-Sep-19
SAS Institute Inc.
Page 01 of 118
SAS ®SQL Query Window User's Guide
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.
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.
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.
, OS/2®, and SQL/DS
Page 03 of 118
4 An Overview of the SQL Query Window 1
Invoking the SQL Query Window 2
Query Window Menus 3
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
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
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
Page 04 of 118
Page 05 of 118
C H A P T E R
An Overview of the SQL Query Window
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...