Practical and Efficient SAS Programming: The Insider*s Guide

Learn to write SAS programs quickly and efficiently.

Programming in SAS is flexible, but it can also be overwhelming. Many novice and experienced programmers learn how to write programs that use the DATA step and macros, but they often don't realize that a simpler or better way can achieve the same results. In a user-friendly tutorial style, Practical and Efficient SAS Programming: The Insider's Guide provides general SAS programming tips that use the tools available in Base SAS, including the DATA step, the SAS macro facility, and SQL.

Drawing from the author's 30 years of SAS programming experience, this book offers self-contained sections that describe each tip or trick and present numerous examples. It therefore serves as both an easy reference for a specific question, and a useful cover-to-cover read. As a bonus, the utility programs included in the appendixes will help you simplify your programs, as well as help you develop a sleek and efficient coding style. With this book, you will learn how to do the following:

• use the DATA step, the SAS macro facility, SQL, and other Base SAS tools more efficiently
• choose the best tool for a task
• use lookup tables
• simulate recursion with macros
• read metadata with the DATA step
• create your own programming style in order to write programs that are easily maintained

Using this book, SAS programmers of all levels will discover new techniques to help them write programs quickly and efficiently.

Martha Messineo is a principal software developer in the SAS Solutions OnDemand division at SAS. She has more than 30 years of SAS experience, most of which she has spent writing SAS programs in a variety of positions, including those in Technical Support, Professional Services, Management Information Systems, SAS Solutions OnDemand, and Research and Development. In her Research and Development role, she worked with SAS Data Integration Studio, IT Resource Management, and SAS Asset Performance Analytics. Before coming to SAS, she worked for MetLife Insurance in the Capacity Planning and Performance Tuning division, where she used SAS to analyze mainframe performance data. She is a SAS Certified Base Programmer for SAS 9, a SAS Certified Advanced Programmer for SAS 9, and a Data Integration developer for SAS 9.