SAS Institute. The Power to Know

Learning Center

More Information

Book Extras

Keep in Touch

SAS Press» Companion Site

Combining and Modifying SAS Data Sets: Examples, Second Edition

About the Book

book cover Combining and Modifying SAS Data Sets: Examples, Second Edition
By: Michele M. Burlew
ISBN: 978-1-59047-920-9
Pages: 250


Anticipated publication date: May 2009


Building on the popularity of the first edition, Michele Burlew has revised this popular examples book to expand the content and address new features in the software. Completely updated for SASŪ9, 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. 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; use of PROC FORMAT and hash tables as table lookups; and generation data sets. Functions and techniques used to reshape and modify observations include those that work with variable type; PROC SQL dictionary tables; creating random samples using the DATA step and PROC SURVEYSELECT; time and date interval calculations; cleaning and validating data values using functions, hash tables, and regular expressions.

About the Author

author photo Michele M. Burlew, president of Episystems, Inc., designs and programs SAS applications for data management, data analysis, report writing, and graphics for academic and corporate clients. A SAS user since 1980, she has expertise in many SAS products and operating systems. Burlew is the author of four other SAS Press books: Debugging SAS Programs: A Handbook of Tools and Techniques, Reading External Data Files Using SAS: Examples Handbook, SAS Guide to Report Writing: Examples, Second Edition, and SAS Macro Programming Made Easy.