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

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

PostgreSQL : Up and Running

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

Paperback

RRP $85.75

$43.75

49%
OFF

T-SQL Fundamentals

Developer Reference

Paperback

RRP $87.13

$72.75

17%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

SQL All-in-One For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $65.95

$49.75

25%
OFF

SQL Tuning

O'Reilly Ser.

Paperback

RRP $75.99

$39.75

48%
OFF

97 Things Every Programmer Should Know

OREILLY

Paperback

RRP $76.00

$39.75

48%
OFF

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Paperback

RRP $125.75

$60.99

51%
OFF

Efficient MySQL Performance

Best Practices and Techniques

Paperback

RRP $125.75

$60.99

51%
OFF

Domain-Specific Small Language Models - Guglielmo Iozzia

$89.99

41%
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

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

$47.75

50%
OFF

Transact-SQL Cookbook

Cookbooks Ser.

Paperback

RRP $76.00

$39.75

48%
OFF

Web Database Applications with PHP and MySQL 2e

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Mastering Oracle SQL 2e

O'Reilly Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle PL/SQL Best Practices

O'Reilly Ser.

Paperback

RRP $57.00

$30.75

46%
OFF

MySQL in a Nutshell

A Desktop Quick Reference

Paperback

RRP $66.75

$34.99

48%
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

PHP & MySQL

The Missing Manual

Paperback

RRP $76.00

$39.75

48%
OFF

SQL and Relational Theory, 3e

Paperback

RRP $76.00

$39.75

48%
OFF

Using SQLite

OREILLY

Paperback

RRP $95.00

$47.75

50%
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

PostgreSQL : Up and Running

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

T-SQL Fundamentals

Developer Reference

SQL Pocket Guide

A Guide to SQL Usage

SQL All-in-One For Dummies

For Dummies (Computer/Tech)

SQL Tuning

O'Reilly Ser.

97 Things Every Programmer Should Know

OREILLY

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Efficient MySQL Performance

Best Practices and Techniques

Domain-Specific Small Language Models

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Oracle PL/SQL Programming

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Sams Teach Yourself SQL in 10 Minutes a Day

5th edition

Learning Oracle PL/SQL

Learning Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Web Database Applications with PHP and MySQL 2e

OREILLY

Mastering Oracle SQL 2e

O'Reilly Ser.

Oracle PL/SQL Best Practices

O'Reilly Ser.

MySQL in a Nutshell

A Desktop Quick Reference

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Head First PHP & MySQL

A Brain-friendly Guide

PHP & MySQL

The Missing Manual

SQL and Relational Theory, 3e

Using SQLite

OREILLY

This product is categorised by