- Title Page
- Copyright
- Additional Resources
- What’s New in Step-by-Step Programming with Base SAS 9.4
- Accessibility Features of Step-by-Step Programming with Base SAS 9.4
- About This Book
- Part 1: Introduction to the SAS System
- Part 2: Getting Your Data into Shape
- Chapter 3: Introduction to DATA Step Processing
- Chapter 4: Starting with Raw Data: The Basics
- Chapter 5: Starting with Raw Data: Beyond the Basics
- Introduction to Beyond the Basics with Raw Data
- Testing a Condition Before Creating an Observation
- Creating Multiple Observations from a Single Record
- Reading Multiple Records to Create a Single Observation
- Problem Solving: When an Input Record Unexpectedly Does Not Have Enough Values
- Summary
- Learning More
- Chapter 6: Starting with SAS Data Sets
- Part 3: Basic Programming
- Chapter 7: Understanding DATA Step Processing
- Chapter 8: Working with Numeric Variables
- Chapter 9: Working with Character Variables
- Introduction to Working with Character Variables
- Input SAS Data Set for Examples
- Identifying Character Variables and Expressing Character Values
- Setting the Length of Character Variables
- Handling Missing Values
- Creating New Character Values
- Saving Storage Space by Treating Numbers as Characters
- Summary
- Learning More
- Chapter 10: Acting on Selected Observations
- Chapter 11: Creating Subsets of Observations
- Chapter 12: Working with Grouped or Sorted Observations
- Chapter 13: Using More Than One Observation in a Calculation
- Chapter 14: Finding Shortcuts in Programming
- Chapter 15: Working with Dates in the SAS System
- Part 4: Combining SAS Data Sets
- Chapter 16: Methods of Combining SAS Data Sets
- Chapter 17: Concatenating SAS Data Sets
- Chapter 18: Interleaving SAS Data Sets
- Chapter 19: Merging SAS Data Sets
- Chapter 20: Updating SAS Data Sets
- Chapter 21: Modifying SAS Data Sets
- Chapter 22: Conditionally Processing Observations from Multiple SAS Data Sets
- Part 5: Debugging SAS Programs
- Chapter 23: Analyzing Your SAS Session with the SAS Log
- Chapter 24: Directing SAS Output and the SAS Log
- Introduction to Directing SAS Output and the SAS Log
- Input File and SAS Data Set for Examples
- Routing the Output and the SAS Log with PROC PRINTTO
- Storing the Output and the SAS Log in the SAS Windowing Environment
- Redefining the Default Destination in a Batch or Noninteractive Environment
- Summary
- Learning More
- Chapter 25: Diagnosing and Avoiding Errors
- Chapter 26: Finding Logic Errors in Your Program
- Part 6: Producing Reports
- Part 7: Producing Plots and Charts
- Part 8: Designing Your Own Output
- Chapter 32: Writing Lines to the SAS Log or to an Output File
- Chapter 33: Understanding and Customizing SAS Output: The Basics
- Introduction to the Basics of Understanding and Customizing SAS Output
- Understanding Output
- Input SAS Data Set for Examples
- Locating Procedure Output
- Making Output Informative
- Controlling Output Appearance of Listing Output
- Controlling the Appearance of Pages
- Representing Missing Values
- Summary
- Learning More
- Chapter 34: Understanding and Customizing SAS Output: The Output Delivery System (ODS)
- Introduction to Customizing SAS Output By Using the Output Delivery System
- Input Data Set for Examples
- Understanding ODS Output Formats and Destinations
- Selecting an Output Format
- Creating Formatted Output
- Selecting the Output That You Want to Format
- Customizing ODS Output
- Storing Links to ODS Output
- Summary
- Learning More
- Part 9: Storing and Managing Data in SAS Files
- Part 10: Understanding Your SAS Environment
- Part 11: Appendix
- Glossary
- Index
Understanding the MERGE Statement
You merge data sets using the MERGE statement in a DATA
step. The form of the MERGE statement that is used in this section
is the following:
MERGE SAS-data-set-list;
BY variable-list;
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.