Advanced SQL with SAS e-bog
436,85 DKK
(inkl. moms 546,06 DKK)
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 ad...
E-bog
436,85 DKK
Forlag
SAS Institute
Udgivet
1 maj 2022
Længde
428 sider
Genrer
Computer programming / software engineering
Sprog
English
Format
epub
Beskyttelse
LCP
ISBN
9781955977890
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"e;Blind spots"e; like how missing values can affect even the simplest calculations and table joinsSAS macro language and SAS macro programsSAS functionsIntegrity constraints SAS DictionariesSAS Compute Server