Fundamentals of Programming in SAS

Chapter 7: Advanced DATA Step Concepts

7.1 Learning Objectives

7.2 Case-Study Activity

7.3 Reading Complex Raw Data Structures

7.3.1 Creating A Single Observation from Multiple Rows

7.3.2 Creating Multiple Observations from A Single Row

7.4 Working Across Records in the DATA Step

7.4.1 RETAIN Statement

7.4.2 DATA Step Sum Statement

7.4.3 BY-Group Processing

7.5 Customizations in the REPORT Procedure

7.5.1 Defining Styles in PROC REPORT

7.5.2 Computing New Variables in PROC REPORT

7.5.3 Using Compute Blocks to Insert Customized Text and Set Styles

7.6 Connecting to Spreadsheets and Relational Databases

7.6.1 Connecting to and Working with Data in Excel Spreadsheets

7.6.2 Connecting to and Working with Data in Access Databases

7.7 Wrap-Up Activity ...