Advanced SQL with SAS
- Length: 428 pages
- Edition: 1
- Language: English
- Publisher: SAS Institute
- Publication Date: 2022-05-19
- ISBN-10: 1955977909
- ISBN-13: 9781955977906
- Sales Rank: #2016291 (See Top 100 Books)
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
Copyright Page Contents Preface About This Book About the Author Chapter 1: Overview Chapter 2: Missing Values Chapter 3: Data Quality with PROC SQL Chapter 4: Macro Programming with PROC SQL Chapter 5: SQL for Geodata Chapter 6: Hash Programming as an Alternative to SQL Chapter 7: FedSQL Chapter 8: Performance and Efficiency Chapter 9: Tips, Tricks, and More Chapter 10: SAS Syntax - PROC SQL, SAS Functions, and SAS CALL Routines References Syntax Index Subject Index Ad
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.