Overview

This chapter describes how you use Structured Query Language (SQL) and the SQL Editor window to perform queries for both the SAS SQL procedure and DB2 SQL. This chapter is intended for users who are familiar with SQL statements and syntax, and who have worked with SQL programs.

This chapter shows examples based on SAS AIRLINE sample tables. See Returning to SAS/ASSIST Windows from the Output Window for information on how to create these sample tables

The SQL Editor window enables you to code and submit SQL SELECT statements (also called queries). You can also code and submit non-query SQL statements, such as CREATE or DROP. The SQL Editor window uses the Query Manager to get information about tables and views. Templates of SQL code are then generated based on these Query Manager selections.

You can also use the SQL Editor window to include queries that are generated from the Query window, queries that are stored in external files, or IBM QMF queries that have been migrated to Query and Reporting. Query results can be saved as SAS tables (that is, SAS data files or data views) or DB2 tables. For more information on migrating from QMF to Query and Reporting, see Migrating from QMF to SAS/ASSIST Software.

Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.