Get Free Shipping on orders over $79
Advanced SQL with SAS - Christian FG Schendera

Advanced SQL with SAS

By: Christian FG Schendera

Hardcover | 19 May 2022

At a Glance

Hardcover


$167.74

or 4 interest-free payments of $41.94 with

 or 

Ships in 5 to 7 business days

This book introduces advanced techniques for using PROC SQL in SAS. If you are a SAS programmer, analyst, or student who has mastered the basics of working with SQL, Advanced SQL with SAS(R) will help take your skills to the next level. Filled with practical examples with detailed explanations, this book demonstrates how to improve performance and speed for large data sets. Although the book addresses advanced topics, it is designed to progress from the simple and manageable to the complex and sophisticated.

In addition to numerous tuning techniques, this book also touches on implicit and explicit pass-throughs, presents alternative SAS grid- and cloud-based processing environments, and compares SAS programming languages and approaches including FedSQL, CAS, DS2, and hash programming. Other topics include:

  • Missing values and data quality with audit trails
  • "Blind spots" like how missing values can affect even the simplest calculations and table joins
  • SAS macro language and SAS macro programs
  • SAS functions
  • Integrity constraints
  • SAS Dictionaries
  • SAS Compute Server
Industry Reviews

"Dr. Christian Schendera's insight into the nuanced aspects of data processing and analysis is unparalleled. In Advanced SQL with SAS, he explains and expands upon the practical and advanced uses of SQL and FedSQL in a digestible and meaningful way. His explanatory approach is not only refreshing, but practical, and the book format allows SQL programmers to take what they need based upon their topic of interest. Knowing what is sustainable, valid, or performant in a given situation is just as important, if not more important, in empowering informed decisions.

 

The book is by a SAS user who wants other SAS users to achieve success rapidly. Advanced SQL with SAS has hundreds of code examples. Special features of the SQL syntax and the generated SAS output are carefully explained in this book. I like the subtle redundancy here. Readers can start at any point in the book at any time. Further, the chapters are organized by degrees of difficulty and complexity. Readers can start with simple and basic topics and progressively dive into more challenging topics. In other words, beginners can begin from scratch; advanced users can reassure themselves that they have not overlooked anything. I was pleasantly surprised to find a chapter on FedSQL. This chapter alone makes this book worth reading."


???Maria A. ReGester, Ph.D

More in Database Programming

SQL Tuning : O'Reilly Ser. - Dan Tow

RRP $75.99

$39.75

48%
OFF
T-SQL Fundamentals : Developer Reference - Itzik Ben-Gan

RRP $87.13

$72.75

17%
OFF
97 Things Every Programmer Should Know : OREILLY - Kevlin Henney

RRP $76.00

$39.75

48%
OFF
Efficient MySQL Performance : Best Practices and Techniques - Daniel Nichter
Domain-Specific Small Language Models - Guglielmo Iozzia
Oracle PL/SQL Programming - Steven Feuerstein

RRP $152.00

$89.99

41%
OFF
Head First PHP & MySQL : A Brain-friendly Guide - Lynn Beighley

RRP $104.75

$51.75

51%
OFF
SQL Pocket Guide : A Guide to SQL Usage - Alice Zhao

RRP $68.75

$35.99

48%
OFF
Learning Oracle PL/SQL : Learning Ser. - Bill Pribyl

RRP $95.00

$47.75

50%
OFF
Transact-SQL Cookbook : Cookbooks Ser. - Ales Spetic

RRP $76.00

$39.75

48%
OFF
Web Database Applications with PHP and MySQL 2e : OREILLY - Hugh E Williams
Oracle PL/SQL Best Practices : O'Reilly Ser. - Steven Feuerstein

RRP $57.00

$30.75

46%
OFF
PHP & MySQL : The Missing Manual - Brett Mclaughlin

RRP $76.00

$39.75

48%
OFF
Mastering Oracle SQL 2e : O'Reilly Ser. - Sanjay Mishra

RRP $95.00

$47.75

50%
OFF
MySQL in a Nutshell : A Desktop Quick Reference - Russell J. T. Dyer

RRP $66.75

$34.99

48%
OFF
LINQ Pocket Reference : Pocket Reference (O'Reilly) - Joseph Albahari
Using SQLite : OREILLY - Jay A. Kreibich

RRP $95.00

$47.75

50%
OFF
Perl Programming in easy steps : In Easy Steps - Mike McGrath

RRP $55.99

$47.99

14%
OFF
Programming Hive : OREILLY AND ASSOCIATE - Edward Capriolo

RRP $76.00

$39.75

48%
OFF