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. Expanded 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, the use of PROC FORMAT and hash tables as table lookups, and generation data sets. Unique features of this book include the following