Step-by-step examples are your guide as you use the windowing interface to the SQL procedure. The SQL Query window supports the PROC SQL Pass-Through Facility and enables you to access data through remote hosts using SAS/CONNECT software. You can also design reports with PROC REPORT based on your SQL Query window's output. In this guide you will learn basic query concepts, how to perform basic queries on single and multiple tablesm how to use advanced SQL Query window features, and how to customize the SQL Query window environment. This title is also available online. This guide is written for those who are familiar with basic SAS terminology and concepts. No previous experience with PROC SQL or SAS code is needed. Supports releases 9.1 and higher of SAS software.

Discover the SQL Query window, which provides an easy-to-use windowing interface to the SQL procedure. A comprehensive overview and step-by-step examples show you how to query SAS data sets and data from database management systems. The SQL Query window supports the PROC SQL Pass-Through facility and enables you to access data through remote hosts using SAS/CONNECT software. You can also design reports with PROC REPORT based on your SQL Query window's output. This title is written for those who are familiar with basic SAS terminology and concepts. No previous experience with PROC SQL or SAS code is needed. This title is available for purchase as a hardcopy book or e-book, or in the SAS OnlineDoc CD-ROM with PDF files. The HTML version of the SAS OnlineDoc CD-ROM is shipped free with Version 8.

Explains how to design reports with PROC REPORT based on your output from the SQL Query Window. Covers basic query concepts, how to perform queries on single and multiple tables, how to use advanced SQL Query Window features, and how to customize the SQL Query Window environment.

In PROC SQL by Example: Using SQL within SAS, author Howard Schreier illustrates the use of PROC SQL in the context of the SAS DATA step and other SAS procedures (such as SORT, FREQ, MEANS, SUMMARY, APPEND, DATASETS, and TRANSPOSE) whose functionality overlaps and complements that of SQL. Using a side-by-side approach, this concise reference guide includes many extensively explained examples showing equivalent DATA step and SQL code, enabling SAS users to take advantage of existing SAS skills and knowledge while learning about SQL. Discussions cover the differences between SQL and the DATA step as well as situations where SQL and the DATA step are used together to benefit from the strengths of each. Topics addressed include working with joins and merges; using subqueries; understanding set operators; using the Macro Facility with PROC SQL; maintaining tables; working with views; using PROC SQL as a report generator; and more. This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL. This book is part of the SAS Press program.

This supplement describes the SAS/ACCESS features and options that are available for Microsoft SQL Server. When you use this supplement along with SAS/ACCESS Interface to Relational Databases: Reference, you will have a comprehensive guide to SAS/ACCESS software for your database management system (DBMS). This supplement explains how SAS/ACCESS software has been customized to accommodate the particular requirements and capabilities of your DBMS. This title is also available online. This title is designed for users of SAS/ACCESS software who need specific information about Microsoft SQL Server. Supports releases 9.1 and higher of SAS software.