Debugging SAS Programs: A Handbook of Tools and Techniques [Paperback]

Michelle Burlew (Author)

Book Description

ISBN-10: 1580259278 | ISBN-13: 978-1580259279 | Publication Date: September 24, 2001 | Edition: 1

What does saving CPU space and time mean to you? If your answer is MONEY...read on! Virgile shares his expertise on reducing the CPU time required to run your SAS jobs with discussion about reading data, reporting, handling files, sorting, and summarizing and manipulating data. He also provides pointed strategies for reducing storage space. Virgile's skillful delivery of programming techniques and strategies enables you to validate your program's efficiency for present and future use through a clever icon system that rates the individual computing savings. The test programs are also available from the SAS Online Samples facility to verify results. This book is written for the experienced SAS programmer.

Editorial Reviews

Review

Michele Burlew has done an excellent job on a topic that is not well publicized: how to debug a SAS program. It is obvious Michele has spent considerable time writing this book, supplying examples of SAS programs with errors, error messages, and solutions to errors. --Charles Patridge, The Hartford

I especially like the chapter at the back of the book where you can look up obscure messages and see what the likely causes are--very usable stuff. --Philip Mason

Product Details

• Paperback: 360 pages
• Publisher: SAS Publishing; 1 edition (September 24, 2001)
• Language: English
• ISBN-10: 1580259278
• ISBN-13: 978-1580259279
• Product Dimensions: 8.9 x 7 x 0.7 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #2,042,240 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

4.0 out of 5 stars Kick Out the Jams, November 16, 2004

By 

M. Allen Greenbaum (California) - See all my reviews
(TOP 500 REVIEWER)    (VINE VOICE)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: Debugging SAS Programs: A Handbook of Tools and Techniques (Paperback)

Expert SAS programmer Burlew provides various techniques for interpreting and preventing programming errors in this hefty, (and expensive) technical book from SAS Publishing. While there is a great deal of useful information, the book awkwardly combines the simple and the advanced. For example, chapters 1 and 6 explain automatically generated error messages in SAS logfiles. A great many of these errors are either self-explanatory, unnecessary to understand in the detail presented here, or may not be included in your own program logs. Still, it is very helpful to have these listed and explained in a compact form.

The value of three other chapters will also depend on the experience of the user and the type of software used. One very long chapter is devoted to debugging errors in macros; if you don't use macros, these chapters are of limited use. Another chapter, "Debugging SAS DATA Steps with the DATA Step Debugger," is apparently only for SAS for Windows software. Furthermore, the correct programming is superimposed on very small pictures resembling Windows screens; it is frustrating to read the resulting tiny font size.

Chapter 3, "Debugging SAS Language Programs," is the most helpful one for the intermediate level user. One of the difficulties in SAS and other languages is that a program may run and produce output, but contain undetected errors. Burlew explains a variety of clever options statements and SAS language statements that improve your ability to detect logical, syntactic, and semantic errors. Another nice feature is an Appendix that describes how to build the data sets that are used as exemplars throughout the book.

Chapters are as follows:

1 .Understanding the Types of Errors in SAS Programs, p. 24
2. Reading the SAS Log and Interpreting SAS Messages, p. 29
3. Debugging SAS Language Programs, p. 45
4. Debugging SAS DATA Steps with the DATA Step Debugger, p. 109
5. Debugging SAS Macro Language, p. 139
6. Base SAS Messages, p. 207
7. Macro Facility Messages, p. 293

Two appendices begin on page 325, and an index on page 345. I can recommend this book for experienced users, especially those who know and use macros. (NOTE: Burlew has written a book titled "SAS Macro Programming Made Easy" that may be helpful.) Another guide that will help prevent data set programming errors is the somewhat easier, "Cody's Data Cleaning Techniques Using SAS Software," by Ron Cody.