PROC SQL : beyond the basics using SAS

Format:

Book

Author/Creator:

Lafler, Kirk Paul, Author.

Contributor:

SAS Institute, Contributor.

SAS Institute, Content Provider.

Language:

English

Subjects (All):

SQL (Computer program language).

SAS (Computer file).

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

Second edition.

Other Title:

Beyond the basics using SAS

Place of Publication:

[Place of publication not identified] SAS Institute 2013

Language Note:

English

System Details:

text file

Summary:

Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful "Summary" that precede each chapter to look for help on a specific topic. The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language using discussion and numerous real-world examples. This book is part of the SAS Press program.

Contents:

Designing database tables

Working with data in PROC SQL

Formatting output

Coding PROC SQL logic

Creating, populating, and deleting tables

Modifying and updating tables and indexes

Coding complex queries

Working with views

Troubleshooting and debugging

Tuning for performance and efficiency

Notes:

Bibliographic Level Mode of Issuance: Monograph

ISBN:

9781612907345

1612907342

OCLC:

911395945