The Essential Proc SQL Handbook

For SAS Users

By: Katherine Prairie

Write A Review

Paperback | 15 May 2005

At a Glance

Paperback
588 Pages

Dimensions(cm)
23.01 x 19.0 x 2.59

Paperback

RRP $172.13

$171.75

or 4 interest-free payments of $42.94 with

or

Ships in 5 to 7 business days

Navigate the world of the powerful SQL procedure with Katherine Prairie's 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.

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 $0.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

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

More in Database Programming

SQL All-in-One For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $65.95

$46.17

30%
OFF

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

Paperback

RRP $133.00

$64.75

51%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Paperback

RRP $125.75

$60.99

51%
OFF

SQL Essentials For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $27.95

$19.57

30%
OFF

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Paperback

RRP $105.95

$92.75

12%
OFF

T-SQL Fundamentals

Developer Reference

Paperback

RRP $87.13

$77.75

11%
OFF

SQL Tuning

O'Reilly Ser.

Paperback

RRP $75.99

$39.75

48%
OFF

PostgreSQL : Up and Running

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

Paperback

RRP $85.75

$43.75

49%
OFF

Learning SQL

Generate, Manipulate, and Retrieve Data

Paperback

RRP $125.75

$60.99

51%
OFF

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Paperback

RRP $125.75

$60.99

51%
OFF

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

$47.75

50%
OFF

Transact-SQL Cookbook

Cookbooks Ser.

Paperback

RRP $76.00

$39.75

48%
OFF

Learning Oracle PL/SQL

Learning Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Web Database Applications with PHP and MySQL 2e

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle PL/SQL Best Practices

O'Reilly Ser.

Paperback

RRP $57.00

$30.75

46%
OFF

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Paperback

RRP $38.00

$21.75

43%
OFF

Head First PHP & MySQL

A Brain-friendly Guide

Paperback

RRP $104.75

$51.75

51%
OFF

Efficient MySQL Performance

Best Practices and Techniques

Paperback

RRP $125.75

$60.99

51%
OFF

SQL in a Nutshell

A Desktop Quick Reference

Paperback

RRP $152.00

$73.75

51%
OFF

Perl Programming in easy steps

In Easy Steps

Paperback

RRP $55.99

$45.99

18%
OFF

Foreword	p. vii
Introduction to PROC SQL	p. 1
A little history	p. 2
PROC SQL statements	p. 3
Why learn PROC SQL?	p. 3
Adaptability	p. 7
When not to use PROC SQL	p. 9
The PROC SQL advantage	p. 10
Working with PROC SQL	p. 11
PROC SQL concepts	p. 12
PROC SQL versus SAS DATA Step	p. 20
PROC SQL naming convention	p. 25
PROC SQL comments	p. 27
LIBNAME statement	p. 28
DESCRIBE statement	p. 30
Working with databases	p. 31
PROC SQL options	p. 35
PROC SQL output options	p. 41
Understanding the SELECT Statement	p. 45
SELECT statement	p. 46
SQL Pass-Through Facility SELECT statement	p. 50
SELECT and FROM clauses	p. 52
SELECT clause	p. 54
FROM clause	p. 69
WHERE clause	p. 72
ORDER BY clause	p. 97
GROUP BY clause	p. 102
HAVING clause	p. 115
ON clause	p. 123
USING clause	p. 125
INTO clause	p. 127
Putting it all together	p. 128
Functions	p. 131
SAS functions and PROC SQL	p. 131
Single functions	p. 135
Summary Functions	p. 150
Working with Two or More Tables	p. 161
Join operations	p. 162
Set operators	p. 210
Subqueries	p. 231
Putting it all together	p. 261
Creating and Managing Tables and Views	p. 265
Why use tables and views?	p. 266
Creating tables	p. 271
Creating views	p. 292
Effective use of indexes	p. 302
Modifying tables and views	p. 331
Putting it all together	p. 376
Building Interactive Applications	p. 385
Validating SQL statements	p. 386
Use of macro variables	p. 386
SAS Component Language (SCL) for user input	p. 411
htmSQL	p. 419
Dictionary tables	p. 435
Putting it all together	p. 448
PROC SQL Enhancements in Version 9	p. 453
Working with PROC SQL	p. 454
Understanding the SELECT statement	p. 461
Functions	p. 462
Creating and maintaining tables	p. 462
Interactive applications	p. 462
SAS/ACCESS interface	p. 465
Bluesky Publishing Tables	p. 469
Bluesky Publishing Tables	p. 481
Information for Database Users	p. 493
Quick References	p. 525
References	p. 543
Index	p. 545
Table of Contents provided by Ingram. All Rights Reserved.

The Essential Proc SQL Handbook

For SAS Users

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Database Programming

SQL All-in-One For Dummies

For Dummies (Computer/Tech)

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

SQL Pocket Guide

A Guide to SQL Usage

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

SQL Essentials For Dummies

For Dummies (Computer/Tech)

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

T-SQL Fundamentals

Developer Reference

SQL Tuning

O'Reilly Ser.

PostgreSQL : Up and Running

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

Learning SQL

Generate, Manipulate, and Retrieve Data

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Domain-Specific Small Language Models

Sams Teach Yourself SQL in 10 Minutes a Day

5th edition

Mastering Oracle SQL 2e

O'Reilly Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Learning Oracle PL/SQL

Learning Ser.

Web Database Applications with PHP and MySQL 2e

OREILLY

Oracle PL/SQL Best Practices

O'Reilly Ser.

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Head First PHP & MySQL

A Brain-friendly Guide

Efficient MySQL Performance

Best Practices and Techniques

SQL in a Nutshell

A Desktop Quick Reference

Perl Programming in easy steps

In Easy Steps

This product is categorised by