Advanced SQL with SAS

By: Christian FG Schendera

Write A Review

Paperback | 19 May 2022

At a Glance

Paperback
428 Pages

Dimensions(cm)
27.94 x 20.96 x 2.21

Paperback

$129.59

or 4 interest-free payments of $32.40 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

"Christian Schendera's Advanced SQL with SAS is an invaluable resource that covers a variety of topics clearly and simply. Given the breadth and depth of this book, I would highly recommend it to a range of users with some prior SQL knowledge."

Frank Ivis

SAS User

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.