Providing both a compendium of reusable and adaptable code, and opportunities for deepening your understanding and growing as a SAS programmer, this pragmatic, example-driven reference offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more. --
For SAS programmers or analysts who need to generalize their programs or improve programming efficiency, Art Carpenter thoroughly updates his highly successful second edition of Carpenter's Complete Guide to the SAS Macro Language with an extensive collection of new macro language techniques and examples. Addressing the composition and operation of the SAS macro facility and the SAS macro language, this third edition offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more! Users with a basic understanding of Base SAS who are new to the SAS macro language will find more detail, utilities, and references to additional learning opportunities; advanced macro language programmers who need help with data-driven macros and dynamic application development will find greatly expanded treatment of these topics. This revised and enlarged edition includes the following topics: New and expanded introduction to the macro language Functions, automatic macro variables, and macro statements new to the macro language Expanded macro language tools that interface with the operating system Expanded data-driven methodologies used to build dynamic applications Expanded discussion of list processing, with four alternative approaches presented Additional file and data management examples Expanded discussion of CALL EXECUTE and DOSUBL New discussion of using the macro language on remote servers Expanded discussion and examples of macro quoting Far beyond a reference manual issued from an “ivory tower,” this book is pragmatic and example-driven: Yes, you will find syntax examples; yes, the code is explained. But the focus of this book is on actual code used to solve real-world business problems. In fact, an entire appendix is dedicated to listing the nearly 70 classes of problems that are solved by programs covered in this edition. Discussion of the examples elucidates the pros and cons of the particular solution and often suggests alternative approaches. Therefore, this book provides you both a compendium of reusable and adaptable code, and opportunities for deepening your understanding and growing as a SAS programmer.
PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Lafler’s easy-to-follow examples, clear explanations, and handy tips to extend their knowledge of PROC SQL. This third edition explores new and powerful features in SAS® 9.4, including topics such as: IFC and IFN functions nearest neighbor processing the HAVING clause indexes It also features two completely new chapters on fuzzy matching and data-driven programming. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basics Using SAS®, Third Edition, explores this powerful database language using discussion and numerous real-world examples.
This book provides beginners with a thorough foundation in SAS macro programming. The macro facility is a popular part of SAS. Macro programming is a required skill for many SAS programming jobs, and the SAS Advanced Programming Certification Exam tests macro processing concepts. Whether you're looking to become certified, land a job, or increase your skills, you'll benefit from SAS Macro Programming Made Easy, Third Edition. By following Michele Burlew's examples and step-by-step instructions, you'll be able to rapidly perform repetitive programming tasks, to pass information between programming steps more easily, and to make your programming easier to read. Updated for SAS 9.4, this book teaches you the elements of the macro facility (macro variables, macro programs, macro language), how to write a macro program, techniques for macro programming, tips on using the macro facility, how the macro facility fits into SAS, and about the interfaces between the macro facility and other components of SAS. Beginning macro programmers will learn to write SAS macro programs quickly and efficiently. More experienced programmers will find this book useful to refresh their conceptual knowledge and expand on their macro programming skills. Ultimately, any user interested in automating their programs—including analysts, programmers, and report writers—will find Michele Burlew's book an excellent tutorial. -- Michele M. Burlew
Increase the modularity, flexibility, and maintainability of your SAS code with the SAS macro facility. This comprehensive reference provides complete information about macro language elements, interfaces between the macro facility and other parts of SAS software, and macro processing in general. With this title, you will learn how to create efficient and portable macro code, reduce the amount of text needed for common tasks, integrate macros with other parts of your SAS programs, and debug macros during development. This title is also available online. To take advantage of this book, you should have at least an intermediate knowledge of Base SAS programming. Supports releases 9.1 and higher of SAS software.
Learn to program SAS by example! Learning SAS by Example, A Programmer’s Guide, Second Edition, teaches SAS programming from very basic concepts to more advanced topics. Because most programmers prefer examples rather than reference-type syntax, this book uses short examples to explain each topic. The second edition has brought this classic book on SAS programming up to the latest SAS version, with new chapters that cover topics such as PROC SGPLOT and Perl regular expressions. This book belongs on the shelf (or e-book reader) of anyone who programs in SAS, from those with little programming experience who want to learn SAS to intermediate and even advanced SAS programmers who want to learn new techniques or identify new ways to accomplish existing tasks. In an instructive and conversational tone, author Ron Cody clearly explains each programming technique and then illustrates it with one or more real-life examples, followed by a detailed description of how the program works. The text is divided into four major sections: Getting Started, DATA Step Processing, Presenting and Summarizing Your Data, and Advanced Topics. Subjects addressed include Reading data from external sources Learning details of DATA step programming Subsetting and combining SAS data sets Understanding SAS functions and working with arrays Creating reports with PROC REPORT and PROC TABULATE Getting started with the SAS macro language Leveraging PROC SQL Generating high-quality graphics Using advanced features of user-defined formats and informats Restructuring SAS data sets Working with multiple observations per subject Getting started with Perl regular expressions You can test your knowledge and hone your skills by solving the problems at the end of each chapter.
For SAS programmers or analysts who need to generalize their programs or improve programming efficiency, Art Carpenter thoroughly updates his successful second edition of Carpenter's Complete Guide to the SAS Macro Language with an extensive collection of new macro language techniques and examples. Addressing the composition and operation of the SAS macro facility and the SAS macro language, this third edition offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more! Users with a basic understanding of Base SAS who are new to the SAS macro language will find more detail, utilities, and references to additional learning opportunities; advanced macro language programmers who need help with data-driven macros and dynamic application development will find greatly expanded treatment of these topics.
A love that says . . . "I will be there for you even when there is nothing I can do." We wordlessly say . . . "Here I am. I have come to sit beside you." Why do we have such shame around our needs? No one wants to be called "needy." And yet, when you have a child with special needs, you realize you have to change your perspective on this word. How do we let our children know their needs are not occasions for shame but rather an opportunity for community? Kimberly Sanders generously shares the unpredictable struggle and rich lessons learned through Lukas, her son who has both Down Syndrome and Autism. This memoir not only explores Lukas' needs, but also how he illuminates her special needs . . . ones we all share, but often try to dismiss or hide. In a society that celebrates big platforms, bold voices, and fast action, Lukas reveals the beauty found in small victories, speaking without words, and slow, hard-earned transformations. Beside You is a powerful and grace-filled memoir told in vignettes, covering the first 10 years of Lukas' life. It gives you a peek behind the curtain into the sacred space of a mother's tender and resilient heart. Join her as she sits beside her children in the muck and mystery of life. Their story is spiritual, vulnerable, and relentlessly hopeful.
See how data science can answer the questions your business faces! Applying Data Science: Business Case Studies Using SAS, by Gerhard Svolba, shows you the benefits of analytics, how to gain more insight into your data, and how to make better decisions. In eight entertaining and real-world case studies, Svolba combines data science and advanced analytics with business questions, illustrating them with data and SAS code. The case studies range from a variety of fields, including performing headcount survival analysis for employee retention, forecasting the demand for new projects, using Monte Carlo simulation to understand outcome distribution, among other topics. The data science methods covered include Kaplan-Meier estimates, Cox Proportional Hazard Regression, ARIMA models, Poisson regression, imputation of missing values, variable clustering, and much more! Written for business analysts, statisticians, data miners, data scientists, and SAS programmers, Applying Data Science bridges the gap between high-level, business-focused books that skimp on the details and technical books that only show SAS code with no business context.
