Advanced SQL with SAS by Christian Fg Schendera (English) Hardcover Book

Description: Advanced SQL with SAS by Christian Fg Schendera 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 joinsSAS macro language and SAS macro programsSAS functionsIntegrity constraints SAS DictionariesSAS Compute Server FORMAT Hardcover LANGUAGE English CONDITION Brand New Author Biography Dr. Christian FG Schendera is a Senior SAS Data Scientist and managing director at Method Consult in Switzerland. An avid SAS user for 30+ years, his experience ranges from scientific consulting, project management, and feature-engineering to statistical modeling using SAS. He studied at Heidelberg University and Martin Luther University Halle-Wittenberg. While still a student, he started consulting in statistics and research methods, lecturing on SAS, applied statistics, and the knowledge-shaping role of non-scientific methods. Christian views constructing knowledge as a two-way street: every step from data collection to applying methods will affect results. He has published several books about statistics, data quality, programming, and SAS. He is author of the most comprehensive double-volume about PROC SQL worldwide. Further information and downloads can be found at www.method-consult.ch. Review "Dr. Christian Schenderas insight into the nuanced aspects of data processing and analysis is unparalleled. In Advanced SQL with SAS, he explains and expands upon the practical and advanced uses of SQL and FedSQL in a digestible and meaningful way. His explanatory approach is not only refreshing, but practical, and the book format allows SQL programmers to take what they need based upon their topic of interest. Knowing what is sustainable, valid, or performant in a given situation is just as important, if not more important, in empowering informed decisions. The book is by a SAS user who wants other SAS users to achieve success rapidly. Advanced SQL with SAS has hundreds of code examples. Special features of the SQL syntax and the generated SAS output are carefully explained in this book. I like the subtle redundancy here. Readers can start at any point in the book at any time. Further, the chapters are organized by degrees of difficulty and complexity. Readers can start with simple and basic topics and progressively dive into more challenging topics. In other words, beginners can begin from scratch; advanced users can reassure themselves that they have not overlooked anything. I was pleasantly surprised to find a chapter on FedSQL. This chapter alone makes this book worth reading."Maria A. ReGester, Ph.D Details ISBN1955977909 Author Christian Fg Schendera Pages 428 Publisher SAS Institute Language English ISBN-10 1955977909 ISBN-13 9781955977906 Year 2022 Format Hardcover Publication Date 2022-05-19 Imprint SAS Institute UK Release Date 2022-05-19 Audience General We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:135368145;

Price: 173.53 AUD

Location: Melbourne

End Time: 2025-02-04T03:38:12.000Z

Shipping Cost: 19.56 AUD