Combining and Modifying SAS Data Sets: Examples, Second Edition

Building on the popularity of the first edition, Michele Burlew has revised this popular examples book to include expanded content and new features of SAS software. Completely updated for SAS 9.2, Combining and Modifying SAS Data Sets: Examples, Second Edition, presents examples that show solutions to common programming tasks that involve combining, modifying, and reshaping data sets. Expanded examples demonstrate how to combine data sets vertically and horizontally; retrieve data from lookup tables; modify and update data sets; combine summary and detail data sets; reshape and transpose observations in a data set; and manipulate data in a data set with utilities and functions. The tools used to combine and modify data sets include the SET, MERGE, MODIFY, and UPDATE statements in the DATA step; joins and set operators in PROC SQL; BY-group processing; indexes; hash objects in the DATA step; the use of PROC FORMAT and hash tables as table lookups; and generation data sets. Unique features of this book include the following: Examples are grouped by task, not by code, so you can easily find a solution to a particular task; alternative solutions are included in the main examples; most examples that combine and modify data sets include both a DATA step and a PROC SQL solution; many examples have an "A Closer Look" section that describes in-depth how the example solves the task; and each example stands on its own so you do not need to read the book from beginning to end. Designed for SAS programmers at all levels, this examples book will help simplify the challenging task of combining and modifying data sets.

Review :
"]]the format of code and explanation on one page and the resulting output on the facing page makes following the examples quite simple. The examples build on one another and by the end of a chapter the reader has a very good understanding of the topic covered. ODS is very powerful and can be complicated this book really does take the reader through ODS, from the basics and beyond." -- Peter Lund "Looking Glass Analytics" "I haven't enjoyed a technical book as much as I enjoyed reading this one. I've been impressed with the writing styles of all 3 authors, and this book is another easy read. What impressed me was the detail incorporated into every example, and, just when I had a burning question about one example, there was an example there immediately to answer it." -- Philip R. Holland, Consultant and Author "Holland Numerics Ltd." "I particularly like the authors' style, which is both informative and friendly, just like having a top-rate instructor giving you one-to-one training." -- Peter Bennett, Director "I.T. Training Services Limited, UK" "If you want to expand your reporting capabilities multi-fold and avoid hours of troubleshooting, this book is definitely worth a read!" -- Christine Iodice, Statistical Programmer "Exelixis Inc." "Lauren Haworth, author of the previous pioneering book on ODS, has been joined by SAS's own Cynthia Zender, expert on all aspects of SAS reporting, and Michele Burlew, the versatile and prolific author of several other SAS books. With a team like this, SAS users could expect an outstanding resource, and we got it." -- LeRoy Bessler PhD "SAS User Since 1978" "Output Delivery System: The Basics and Beyond is a must-read for SAS users at all levels of experience. The authors certainly know their stuff, and their enthusiasm about the power and flexibility of ODS is evident throughout the book." -- Mike Rhoads "Westat" "This book is the Joy of Cooking for SAS ODS users. It gives good explanations for the ODS novice and is a complete resource for experienced users with questions. It is the book I've been waiting for." -- Cecilia Mauldin "CDD" "Written for the user who wants to learn by following examples, the presentation style is much less a reference manual and much more a guide to 'how to get the problem solved." -- Art Carpenter "CALOXY"