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.
Also Recommended: SAS Guide to the SQL Query Window: Usage and Reference, Version 6, First Edition;
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 sasbook@unx.sas.com.
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.