SAS® Certification Prep Guide: Base Programming for SAS®9 Second Edition

Chapter 13. Combining SAS Data Sets

• Overview 372

  • Introduction 372

  • Objectives 374

• One-to-One Reading 375

  • How One-to-One Reading Selects Data 375

  • How One-to-One Reading Works 376

  • Example 377

• Concatenating 378

  • How Concatenating Selects Data 378

  • Example 379

• Appending 380

  • Requirements for the APPEND Procedure 381

  • Example 382

  • Using the FORCE Option with Unlike-Structured Data Sets 382

  • Example 383

• Interleaving 384

  • How Interleaving Selects Data 384

  • Example 385

• Match-Merging 386

  • How Match-Merging Selects Data 387

  • Example 388

  • Example: Merge in Descending Order 389

• Match-Merge Processing 390

  • The Compilation Phase: Setting Up the New Data Set 391

  • The Execution Phase: Match-Merging Observations 392

  • Handling Unmatched Observations and Missing Values 394

• Renaming Variables 395

• Excluding ...