Audience
The SAS Certification Prep Guide: Base Programming for SAS®9 is for new or experienced SAS
programmers who want to prepare for the SAS Base Programming for SAS®9 exam.
Requirements and Details
Purpose
The SAS Certification Prep Guide: Base Programming for SAS®9 helps prepare you to take the SAS Base
Programming for SAS®9 exam. The book covers the objectives tested on the exam, including basic
concepts, producing reports, creating and modifying SAS data sets, and reading various types of raw data.
Before attempting the exam you should also have experience programming in the SAS®9 environment.
The book includes quizzes that enable you to test your understanding of material in each chapter.
Additionally, solutions to all quizzes are included at the back of the book.
About This Book.....................................................................................................................................................................2
Chapter 1 Base Programming .................................................................................................................................................4
Chapter 2 Referencing Files and Setting Options .................................................................................................................43
Chapter 3 Editing and Debugging SAS Programs ................................................................................................................79
Chapter 4 Creating List Reports..........................................................................................................................................115
Chapter 5 Creating SAS Data Sets from External Files......................................................................................................159
Chapter 6 Understanding DATA Step Processing ...............................................................................................................215
Chapter 7 Creating and Applying User-Defined Formats ...................................................................................................254
Chapter 8 Producing Descriptive Statistics.........................................................................................................................268
Chapter 9 Producing HTML Output ...................................................................................................................................304
Chapter 10 Creating and Managing Variables.....................................................................................................................331
Chapter 11 Reading SAS Data Sets ....................................................................................................................................364
Chapter 12 Combining SAS Data Sets ...............................................................................................................................391
Chapter 13 Transforming Data with SAS Functions...........................................................................................................437
Chapter 14 Generating Data with DO Loops......................................................................................................................506
Chapter 15 Processing Variables with Arrays .....................................................................................................................527
Chapter 16 Reading Raw Data in Fixed Fields...................................................................................................................563
Chapter 17 Reading Free-Format Data ...............................................................................................................................586
Chapter 18 Reading Date and Time Values.........................................................................................................................626
Chapter 19 Creating a Single Observation from Multiple Records ....................................................................................648
Chapter 20 Creating Multiple Observations from a Single Record ....................................................................................671
Chapter 21 Reading Hierarchical Files ...............................................................................................................................706
Appendix 1 Quiz Answer Keys...........................................................................................................................................733
