SAS Programming II: Manipulating Data with the DATA Step
Table of Contents
Course Description...................................................................................................................... vi
Prerequisites ...............................................................................................................................vii
General Conventions .................................................................................................................viii
Chapter 1  Introduction .......................................................................................... 1-1
1.1 Overview..........................................................................................................................1-3
1.2  Review of SAS Basics .....................................................................................................1-7
1.3  Review of DATA Step Processing..................................................................................1-15
1.4  Review of Displaying SAS Data Sets ............................................................................1-21
1.5  Working with Existing SAS Data Sets...........................................................................1-28
1.6  Prerequisite Syntax (Self-Study)....................................................................................1-44
1.7  Navigating the SAS Windowing Environment (Self-Study) .........................................1-47
Chapter 2  Controlling Input and Output .............................................................. 2-1
2.1  Outputting Multiple Observations ...................................................................................2-3
2.2  Writing to Multiple SAS Data Sets................................................................................2-15
2.3  Selecting Variables and Observations ............................................................................2-23
2.4  Writing to an External File.............................................................................................2-39
2.5  Solutions to Exercises ....................................................................................................2-58
Chapter 3  Summarizing Data ................................................................................ 3-1
3.1  Creating an Accumulating Total Variable ........................................................................3-3
3.2  Accumulating Totals for a Group of Data......................................................................3-12
3.3  Solutions to Exercises ....................................................................................................3-30 iv  For Your Information
Chapter 4  Reading and Writing Different Types of Data..................................... 4-1
4.1  Reading Delimited Raw Data Files..................................................................................4-3
4.2  Controlling When a Record Loads.................................................................................4-30
4.3 Reading Hierarchical Raw Data Files ............................................................................4-56
4.4  Solutions to Exercises ....................................................................................................4-90
Chapter 5  Data Transformations........................................................................... 5-1
5.1 Introduction......................................................................................................................5-3
5.2 Manipulating Character Values........................................................................................5-8
5.3 Manipulating Numeric Values .......................................................................................5-39
5.4  Manipulating Numeric Values Based on Dates..............................................................5-48
5.5  Converting Variable Type ..............................................................................................5-53
5.6  Solutions to Exercises ....................................................................................................5-71
Chapter 6  Debugging Techniques (Self-Study) ................................................... 6-1
6.1  Using the PUT Statement.................................................................................................6-3
6.2  Using the DEBUG Option .............................................................................................6-14
Chapter 7  Processing Data Iteratively.................................................................. 7-1
7.1  DO Loop Processing........................................................................................................7-3
7.2 SAS Array Processing....................................................................................................7-27
7.3 Using SAS Arrays ..........................................................................................................7-38
7.4  Solutions to Exercises ....................................................................................................7-53
Chapter 8  Combining SAS® Data Sets ................................................................. 8-1
8.1 Match-Merging Two or More SAS Data Sets..................................................................8-3
8.2  Simple Joins Using the SQL Procedure (Self-Study) ....................................................8-19