![Advanced SQL with SAS](https://img.perlego.com/book-covers/3522667/9781955977890_300_450.webp)
Advanced SQL with SAS
Christian FG Schendera
- 428 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Advanced SQL with SAS
Christian FG Schendera
About This Book
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 ÂŽ 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
Frequently asked questions
Information
Table 1.1 Quick Finder | |
Chapter | Description |
1 | Overview of this book |
2 | Missing values: Definition, mode of operation, and conversion |
3 | Data quality: Integrity constraints (test rules) and audit trails, as well as finding duplicates and outliers. |
4 | Macro programming: From simple macro variables (SAS, SQL, user-defined), to helpful SAS macro programs including macros for list execution of commands or macros for retrieving system information |
5 | SQL for geodata, distances, and maps |
6 | Hashing as an alternative to SQL |
7 | FedSQL |
8 | Performance and efficiency: strategy and measures including narrowing, shortening, and compressing; sorting; and other tips and tricks including SAS dictionaries |
9 | Help, tips, and tricks |
10 | SAS syntax - PROC SQL, SAS functions, and SAS routines |
11 | References |
12 | Syntax index |
13... |
Table of contents
- Cover
- 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