SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Chapter 18Modifying SAS Data Sets and Tracking Changes

Overview

Introduction

Objectives

Using the MODIFY Statement

Modifying All Observations in a SAS Data Set

Overview

Example

Modifying Observations Using a Transaction Data Set

Overview

Example

Handling Duplicate Values

Handling Missing Values

Modifying Observations Located by an Index

Overview

Example

Handling Duplicate Values

Controlling the Update Process

Overview

Example

Monitoring I/O Error Conditions

Using _IORC_ with %SYSRC

Example

Understanding Integrity Constraints

Overview

General Integrity Constraints

Referential Integrity Constraints

Placing Integrity Constraints on a Data Set

Overview

Example

How Constraints Are Enforced

Example

Copying a Data Set and Preserving Integrity Constraints ...