After completing SAS: Combining and Updating Data Sets, the user should be able to:

	Create new data sets through concatenating, interleaving or merging observations
	Update a master data set with values from a transaction data set
	Manipulate a SAS data set in place
	Read a data set twice
	Determine the source of an observation
	Combine portions of data sets
	Read only certain observations
	Access observations nonsequentially

Concatenating Data Sets

	Using the SET statement
	Using PROC APPEND
	Using SET vs. APPEND

Interleaving and Merging Data Sets

	Interleaving
	One-to-one merging
	Match merging

Updating with UPDATE

	Simple updates
	Missing values
	Processing updates
	Changing values to missing
	Summing values
	Aging data set files

Updating with MODIFY

	Updating a data set in place
	Summing values
	MODIFY vs. UPDATE
	Refining MODIFY statements
	Implications of updating in place

Using Other Techniques

	Reading a data set twice
	Determining the source of an observation
	Combining portions of data sets
	Reading only certain observations
	Accessing observations nonsequentially

This course has the following features:

	Exercises that allow users to practice in SAS
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to SAS
	A glossary
	A Skill Assessment

	SAS: Introduction (SAS601)
	SAS: Using SAS (SAS602)
	SAS: Data Manipulation (SAS603)
	SAS: DATA Step Programming (SAS604)
	SAS: Results (SAS605)
	SAS: Display Manager System (SAS606)
	SAS: Data Libraries (SAS607)
	SAS: Inputting Data and PROC SQL (SAS608)

SAS is a registered trademark of SAS Institute Inc.