Contents
List of Programs xv
Preface xxix
Acknowledgments xxxi
Part 1 Getting Started 1
Chapter 1 What Is SAS? 3
Chapter 2 Writing Your First SAS Program 11
Chapter 3 Reading Raw Data from External Files 29
Chapter 4 Creating Permanent SAS Data Sets 53

Chapter 5 Creating Formats and Labels 71
Chapter 6 Reading and Writing Data from an Excel Spreadsheet 87
Chapter 7 Performing Conditional Processing 101

Chapter 8 Performing Iterative Processing: Looping 117
Chapter 9 Working with Dates 141
Chapter 10 Subsetting and Combining SAS Data Sets 161
Chapter 11 Working with Numeric Functions 189
Chapter 12 Working with Character Functions 211
Chapter 13 Working with Arrays 243

Part 3 Presenting and Summarizing Your Data 259
Chapter 14 Displaying Your Data 261
Chapter 15 Creating Customized Reports 287
Chapter 16 Summarizing Your Data 319
Chapter 17 Counting Frequencies 341
Chapter 18 Creating Tabular Reports 363
Chapter 19 Introducing the Output Delivery System 397
Chapter 20 Generating High-Quality Graphics 411
Chapter 21 Using Advanced INPUT Techniques 437

Chapter 22 Using Advanced Features of User-Defined Formats
Chapter 23 Restructuring SAS Data Sets 493
Chapter 24 Working with Multiple Observations per Subject 505
Chapter 25 Introducing the SAS Macro Language 521
Chapter 26 Introducing the Structured Query Language 535