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.75

or 4 interest-free payments of $32.44 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 $79.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.

Defective items

RRP $125.75

$60.99

51%
OFF

Domain-Specific Small Language Models

Hardcover

$152.75

Oracle PL/SQL Programming

Paperback

RRP $152.00

$89.99

41%
OFF

Data Pipelines with Apache Airflow, Second Edition : Orchestration for data and AI - Julian Ruiter

$51.75

51%
OFF

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Paperback

RRP $125.75

$60.99

51%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

Sams Teach Yourself SQL in 10 Minutes a Day : 5th edition - Ben Forta

RRP $55.99

$47.99

14%
OFF

Programming Hive

OREILLY AND ASSOCIATE

Paperback

RRP $76.00

$39.75

48%
OFF

Advanced SQL with SAS

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Database Programming

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

SQL Tuning

O'Reilly Ser.

T-SQL Fundamentals

Developer Reference

97 Things Every Programmer Should Know

OREILLY

Efficient MySQL Performance

Best Practices and Techniques

Domain-Specific Small Language Models

Oracle PL/SQL Programming

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Head First PHP & MySQL

A Brain-friendly Guide

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

SQL Pocket Guide

A Guide to SQL Usage

Sams Teach Yourself SQL in 10 Minutes a Day

5th edition

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Learning Oracle PL/SQL

Learning Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Web Database Applications with PHP and MySQL 2e

OREILLY

Oracle PL/SQL Best Practices

O'Reilly Ser.

PHP & MySQL

The Missing Manual

Mastering Oracle SQL 2e

O'Reilly Ser.

MySQL in a Nutshell

A Desktop Quick Reference

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Using SQLite

OREILLY

Perl Programming in easy steps

In Easy Steps

Programming Hive

OREILLY AND ASSOCIATE

This product is categorised by