Getting Started with the SQL Procedure, First Edition

Filled with code-based examples, this book is ideal for SAS programmers who want to take advantage of the power of the SQL procedure. A part of base SAS, PROC SQL is a powerful reporting tool that can often be an alternative to the DATA step and other SAS procedures. PROC SQL also provides a method for accessing data in external databases for those users who have a SAS/ACCESS license. This book shows examples of how you can use PROC SQL to create, update, modify, and combine SAS data sets, generate reports and more. The last chapter introduces the SQL Query Window in SAS/ASSIST software, which provides a point-and-click interface to PROC SQL. The SQL Query Window chapter contains an example of accessing data in another vendor's database management system.

88 pages.

Table of contents

Also Recommended: SAS Guide to the SQL Query Window: Usage and Reference, Version 6, First Edition;

CMS, Mac, MVS, OS/390, OS/2, UNIX, OpenVMS Alpha, OpenVMS VAX, Windows

ISBN: 1-55544-662-0

Order #CW55042

How To Order

US Customers

To order SAS Institute Publications, call SAS Institute book sales at 1-800-727-3228. (Note: This toll-free number is for ordering books in the U.S. only.) You may also contact book sales by E-mail at

International Customers

To order SAS Institute Publications, contact your local SAS office. International orders sent to the U.S. office will be faxed to the appropriate SAS Subsidiary or Distributor office. Pricing, delivery, and terms for all international documentation orders are determined by each local office.

Copyright © 1999 SAS Institute Inc.