Book description
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.
This book is part of the SAS Press program.
Table of contents
- About This Book
- About The Author
- Acknowledgments
-
Part 1: Understanding the Concepts and Features of Macro Programming
- Chapter 1 Introduction
- Chapter 2 Mechanics of Macro Processing
-
Chapter 3 Macro Variables
- Introduction
- Basic Concepts of Macro Variables
- Referencing Macro Variables
- Understanding Macro Variable Resolution and the Use of Single and Double Quotation Marks
- Displaying Macro Variable Values
- Understanding Automatic Macro Variables
- Understanding User-Defined Macro Variables
- Combining Macro Variables with Text
- Referencing Macro Variables Indirectly
- Chapter 4 Macro Programs
- Chapter 5 Understanding Macro Symbol Tables and the Processing of Macro Programs
- Chapter 6 Macro Language Functions
- Chapter 7 Macro Expressions and Macro Programming Statements
-
Chapter 8 Masking Special Characters and Mnemonic Operators
- Introduction
- Why Are Quoting Functions Called Quoting Functions?
- Illustrating the Need for Macro Quoting Functions
- Describing the Commonly Used Macro Quoting Functions
- Understanding How Macro Quoting Functions Work
- Applying Macro Quoting Functions
- Specifying Macro Program Parameters That Contain Special Characters or Mnemonic Operators
- Unmasking Text and the %UNQUOTE Function
- Using Quoting Versions of Macro Character Functions and Autocall Macro Programs
- Chapter 9 Interfaces to the Macro Facility
-
Part 2: Applying Your Knowledge of Macro Programming
- Chapter 10 Storing and Reusing Macro Programs
- Chapter 11 Building a Library of Utilities
-
Chapter 12 Debugging Macro Programming and Adding Error Checking to Macro Programs
- Introduction
- Understanding the Types of Errors That Can Occur in Macro Programming
- Minimizing Errors in Developing SAS Programs That Contain Macro Language
- Categorizing and Checking for Common Problems in Macro Programming
- Understanding the Tools That Can Debug Macro Programming
- Examples of Solving Errors in Macro Programming
- Improving Your Macro Programming by Including Error Checking
-
Chapter 13 A Stepwise Method for Writing Macro Programs
- Introduction
- Building a Macro Program in Four Steps
-
Applying the Four Steps to an Example
- Step 1: Write, test, and debug the SAS program(s) that you want the macro program to build
- Step 2: Remove hard-coded programming constants from the program(s) in Step 1 and replace these constants with macro variables
- Step 3: Create macro program(s) from the program(s) in Step 2
- Step 4: Refine and generalize the macro program(s) in Step 3 by adding macro language statements like %IF-%THEN and %DO groups
- Executing the REPORT Macro Program
- Enhancing the Macro Program REPORT
- Part 3 Appendixes
- Index
Product information
- Title: SAS Macro Programming Made Easy, Third Edition, 3rd Edition
- Author(s):
- Release date: June 2014
- Publisher(s): SAS Institute
- ISBN: 9781629591513
You might also like
book
Carpenter's Complete Guide to the SAS Macro Language, Third Edition, 3rd Edition
For SAS programmers or analysts who need to generalize their programs or improve programming efficiency, Art …
book
SAS Macro Language Magic
SAS Macro Language Magic: Discovering Advanced Techniques pushes the SAS macro language to the limit. It …
book
Step-by-Step Programming with Base SAS 9.4, Second Edition, 2nd Edition
Provides conceptual information about the SAS programming language, as well as step-by-step examples that illustrate the …
book
SAS® Macro Programming Made Easy, Second Edition
Need help understanding the SAS macro facility? You will find all the answers that you need …