The Essential Proc Sql Handbook For Sas Users by Katherine Sas Institute

The Essential Proc Sql Handbook For Sas Users

byKatherine Sas Institute

Paperback | May 15, 2005

not yet rated|write a review

Pricing and Purchase Info

$98.17 online 
Earn 491 plum® points

In stock online

Ships free on orders over $25

Not available in stores


Navigate the world of the powerful SQL procedure with The Essential PROC SQL Handbook for SAS Users. Written in an easy-to-use, logical format, this comprehensive reference focuses on the functionality of the procedure, as well as the accomplishment of common tasks using PROC SQL, enabling readers to quickly develop and enhance their SQL skills. Features include more than 300 examples of PROC SQL code, plus queries and diagrams showing how the statements are processed, tips and techniques highlighting "need-to-know" concepts, and an appendix designed specifically for SQL Pass-Through Facility and SAS/ACCESS users. This practical guide is written for SAS users of all levels who want to learn how to integrate the SQL procedure into their Base SAS and/or SAS/ACCESS programs as well as SQL programmers who want to adapt their current skills to SAS.

Details & Specs

Title:The Essential Proc Sql Handbook For Sas UsersFormat:PaperbackDimensions:588 pages, 9.25 × 7.5 × 1.19 inPublished:May 15, 2005Publisher:SAS Institute Inc.Language:English

The following ISBNs are associated with this title:

ISBN - 10:1590475712

ISBN - 13:9781590475713

Look for similar items by category:

Customer Reviews of The Essential Proc Sql Handbook For Sas Users


Extra Content

Editorial Reviews

"The Essential PROC SQL Handbook for SAS Users is a well-organized, well-thought out, and very handy reference guide. It is a veritable tome for SQL usage in SAS, a must-have for any SAS user who pulls data from relational tables." Robert Schroko Saks Fifth Avenue   "What a versatile book! It's a tutorial for SAS users that have never used SQL. It's a step-by-step guide for programmers that need to convert existing SQL code into SAS PROC SQL. It is also a resource that any experienced SAS user will find invaluable. Even those who have been using PROC SQL for years can improve their code efficiency and sophistication by spending just a short amount of time with this handbook." Meredith Sterling Bechtold, SAS user    "I think this book is very interesting and educational. It has a logical progression that would fit well as an educational textbook. I may add this book to the curriculum, but would definitely recommend it as another reference textbook for my DBA program." Mark Perry, Oracle Database Administrator Southern Alberta Institute of Technology (SAIT)   "Katherine has taken an industry-wide requirement for SAS and contributed a much desired reference from which users, beginner to guru, will profit. She has expertly taken a complex subject and simplified it in step-by-step format while satisfying us with understandable examples. I found her approach appropriate, straight-forward and undemanding to comprehend..., I strongly advocate this superior manuscript for use in training as well as employing SAS." Greg H. Smith, OCP DBA SAIT (Southern Alberta Institute of Technology)   "The section in Chapter 6 on the SQL optimizer and use of indexes in queries is a perfect example of an often difficult concept for analysts to understand (and thus, often overlooked), yet critical to writing efficient code. SQL optimization and proper use of indexes is important for analysts and programmers to understand when working with large data volumes in a data warehouse environment. The book presents the optimizer and indexing to pics clearly, with good query examples and how to interpret SAS logs... What Katherine illustrates in her book is how powerful and important PROC SQL is to SAS and that it can often be more efficient to use than other SAS code when performing database tasks. The Essential PROC SQL Handbook for SAS Users is the ideal reference for a SQL programmer (novice to expert) new to working in the SAS environment. This book will be the single source reference for PROC SQL within our Data Quality group." Sean O'Neill Citi Cards, Information Business