SAS Certification Review Base Programming for SAS9 官方教程
2007年的，希望对大家考试有用.

Table of Contents
Course Description..................................................................................................................... vi
Prerequisites ...............................................................................................................................vii
Chapter 1 Introduction .......................................................................................... 1-1
1.1 Specifics about the SAS Base Programming Exam.........................................................1-3
1.2 Specifics about This Review Course ...............................................................................1-8
1.3 SAS Fundamental Concepts ..........................................................................................1-12
1.4 Answers to Questions ....................................................................................................1-23
Chapter 2 Working with SAS Data Sets ............................................................... 2-1
2.1 Reading and Creating Data Sets ......................................................................................2-3
2.2 Selecting Observations...................................................................................................2-21
2.3 Sorting Observations with the SORT Procedure............................................................2-30
2.4 Combining Data Sets .....................................................................................................2-33
2.5 Answers to Questions ....................................................................................................2-42
Chapter 3 Working with Raw Data Files............................................................... 3-1
3.1 Reading Raw Data Files: Part 1 .......................................................................................3-3
3.2 Reading Raw Data Files: Part 2 .....................................................................................3-12
3.3 Controlling When a Record Loads.................................................................................3-23
3.4 Creating Raw Data Files ................................................................................................3-28
3.5 Answers to Questions ....................................................................................................3-36
Chapter 4 Creating Variables ................................................................................ 4-1
4.1 Creating Variables with the Assignment Statement .........................................................4-3
4.2 Creating Variables Conditionally .....................................................................................4-8
4.3 Creating Accumulator Variables ....................................................................................4-16
4.4 Answers to Questions ....................................................................................................4-21
Chapter 5 Manipulating Data................................................................................. 5-1
5.1 Using Functions to Manipulate Data ...............................................................................5-3
5.2 Converting Character and Numeric Data.......................................................................5-25
5.3 Processing Data with DO Loops....................................................................................5-31
5.4 Processing Data with Arrays..........................................................................................5-39
5.5 Answers to Questions ....................................................................................................5-44
Chapter 6 Generating Reports .............................................................................. 6-1
6.1 Creating Detail Reports with the PRINT Procedure ........................................................6-3
6.2 Creating Formats with the FORMAT Procedure ...........................................................6-17
6.3 Creating Reports with the REPORT Procedure .............................................................6-22
6.4 Creating Frequency Tables with the FREQ Procedure ..................................................6-31
6.5 Creating Summary Reports with the MEANS Procedure..............................................6-35
6.6 Creating HTML Reports with ODS ...............................................................................6-39
6.7 Answers to Questions ....................................................................................................6-42
Chapter 7 Additional Information ......................................................................... 7-1
7.1 More Specifics about the SAS Base Programming Exam ...............................................7-3
7.2 Additional Preparation Resources....................................................................................7-6
7.3 Test-Taking Strategies....................................................................................................7-10
Appendix A Exercises and Solutions..................................................................... A-1
Exercises..................................................................................................................................A-3
Chapter 1..............................................................................................................................A-3
Chapter 2..............................................................................................................................A-4
Chapter 3..............................................................................................................................A-7
Chapter 4.............................................................................................................................A-10
Chapter 5.............................................................................................................................A-13
Chapter 6.............................................................................................................................A-17
Solutions................................................................................................................................A-24
Chapter 1.............................................................................................................................A-24
Chapter 2.............................................................................................................................A-25
Chapter 3.............................................................................................................................A-27
Chapter 4.............................................................................................................................A-28
Chapter 5.............................................................................................................................A-30
Chapter 6.............................................................................................................................A-32
Appendix B Practice Exam...................................................................................... B-1
B.1 SAS Fundamental Concepts ........................................................................................... B-3
B.2 Working with SAS Data Sets .......................................................................................... B-6
B.3 Working with Raw Data Files....................................................................................... B-11
B.4 Creating Variables......................................................................................................... B-19
B.5 Manipulating Data ........................................................................................................ B-25
B.6 Generating Reports ....................................................................................................... B-30
B.7 Scores........................................................................................................................... B-36
B.8 Answers ........................................................................................................................ B-37
Appendix C Index ..................................................................................................... C-1