Book description
Master the language of PROC SQL! Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) guidelines and non-ANSI features. A broad range of SAS users, including applications programmers, database designers and administrators, statisticians, and systems analysts, will find techniques in Kirk Lafler's PROC SQL: Beyond the Basics Using SAS to enhance their data access, manipulation, and presentation prowess. Topics examined include database design; an introduction to SQL, dictionary tables, and tables; coding PROC SQL logic as well as complex queries; working with views; troubleshooting and debugging SQL code; and tuning for performance. With the growing popularity of databases, PROC SQL is becoming the language of choice for SAS users around the world. Intermediate and advanced users will appreciate the straightforward explanations and numerous examples.
Table of contents
- Copyright
- Preface
- Acknowledgments
- 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
- Glossary
- References
- Call your local SAS office to order these books from Books by Users Press
- Index
Product information
- Title: PROC SQL: Beyond the Basics Using SAS®
- Author(s):
- Release date: September 2004
- Publisher(s): SAS Institute
- ISBN: 9781590475348
You might also like
book
PROC SQL, 3rd Edition
PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps …
book
PROC SQL: Beyond the Basics Using SAS, Second Edition
Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide …
book
SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition
Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information …
book
SAS Data Integration Studio 4.9
Describes the main tasks that you can perform in SAS Data Integration Studio, including: data access; …