O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SAS Certification Prep Guide, 4th Edition

Book Description

Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program.

New and experienced SAS users who want to prepare for the SAS Base Programming for SAS 9 exam will find this guide to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam. Now in its fourth edition, the guide has been extensively updated, and revised to streamline explanations.

Major topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors. The chapter quizzes have been thoroughly updated and full solutions are included at the back of the book. In addition, links are provided to the exam objectives, practice exams, and other helpful resources, such as the updated Base SAS glossary and an expanded collection of practice data sets.

Content updates are available here.

Table of Contents

  1. Title Page
  2. Copyright
  3. Accessibility Features of the SAS Certification Prep Guide
  4. How to Prepare for the SAS Base Programming for SAS®9 Exam
  5. Chapter 1: Setting Up Practice Data
    1. Determine What SAS Solution or Environment You Are Using
    2. Determine Whether You Have Write Access
    3. SAS Windowing Environment
    4. SAS Studio and SAS University Edition
    5. SAS Enterprise Guide
  6. Chapter 2: Basic Concepts
    1. Getting Started
    2. The Basics of the SAS Language
    3. SAS Libraries
    4. Referencing SAS Files
    5. SAS Data Sets
    6. Chapter Quiz
  7. Chapter 3: Setting Up Your SAS Session
    1. SAS Libraries
    2. Viewing SAS Libraries
    3. Specifying Results Formats
    4. Setting System Options
    5. Chapter Quiz
  8. Chapter 4: Identifying and Correcting Errors
    1. Error Messages
    2. Correcting Common Errors
    3. Chapter Quiz
  9. Chapter 5: Creating List Reports
    1. Creating a Basic Report
    2. Selecting Variables
    3. Identifying Observations
    4. Sorting Data
    5. Generating Column Totals
    6. Double Spacing LISTING Output
    7. Specifying Titles and Footnotes in Procedure Output
    8. Assigning Descriptive Labels
    9. Formatting Data Values
    10. Using Permanently Assigned Labels and Formats
    11. Chapter Quiz
  10. Chapter 6: Creating SAS Data Sets from External Files
    1. Raw Data Files
    2. Creating a SAS Data Set from a Raw Data File
    3. Referencing a Raw Data File
    4. DATA Step Statements for Reading Data
    5. Reading and Verifying the Data
    6. Creating and Modifying Variables
    7. Subsetting Data
    8. Reading Instream Data
    9. Creating a Raw Data File
    10. Reading Microsoft Excel Data
    11. LIBNAME Statement Options
    12. Creating Excel Worksheets
    13. The IMPORT Procedure
    14. Chapter Quiz
  11. Chapter 7: Understanding DATA Step Processing
    1. How SAS Processes Programs
    2. Compilation Phase
    3. Execution Phase
    4. Debugging a DATA Step
    5. Testing Your Programs
    6. Chapter Quiz
  12. Chapter 8: Creating and Applying User-Defined Formats
    1. The FORMAT Procedure
    2. Defining a Unique Format
    3. Associating User-Defined Formats with Variables
    4. Chapter Quiz
  13. Chapter 9: Producing Descriptive Statistics
    1. Computing Statistics Using PROC MEANS
    2. Selecting Statistics
    3. Limiting Decimal Places
    4. Specifying Variables in PROC MEANS
    5. Group Processing Using the CLASS Statement
    6. Group Processing Using the BY Statement
    7. Creating a Summarized Data Set Using PROC MEANS
    8. Creating a Summarized Data Set Using PROC SUMMARY
    9. Producing Frequency Tables Using PROC FREQ
    10. Specifying Variables in PROC FREQ
    11. Creating Two-Way Tables
    12. Creating N-Way Tables
    13. Creating Tables in List Format
    14. Chapter Quiz
  14. Chapter 10: Creating Output with ODS
    1. The Output Delivery System (ODS)
    2. Creating HTML Output with ODS
    3. Creating PDF Output with ODS
    4. Creating RTF Output with ODS
    5. Creating EXCEL Output with ODS
    6. Chapter Quiz
  15. Chapter 11: Creating and Managing Variables
    1. Creating and Modifying Variables
    2. Assigning Values Conditionally
    3. Specifying Lengths for Variables
    4. Subsetting Data
    5. Assigning Permanent Labels and Formats
    6. Assigning Values Conditionally Using SELECT Groups
    7. Grouping Statements Using DO Groups
    8. Chapter Quiz
  16. Chapter 12: Reading SAS Data Sets
    1. Reading a Single Data Set to Create Another
    2. Manipulating Data
    3. Using BY-Group Processing
    4. Writing Observations Explicitly
    5. Detecting the End of a Data Set
    6. Chapter Quiz
  17. Chapter 13: Combining SAS Data Sets
    1. How to Prepare Your Data Sets
    2. Methods of Combining SAS Data Sets: The Basics
    3. One-to-One Reading: Details
    4. Concatenating: Details
    5. Appending: Details
    6. Interleaving: Details
    7. Match-Merging: Details
    8. Match-Merge Processing
    9. Renaming Variables
    10. Excluding Unmatched Observations
    11. Selecting Variables
    12. Chapter Quiz
  18. Chapter 14: Using Functions to Manipulate Data
    1. The Basics of SAS Functions
    2. SAS Functions Syntax
    3. Converting Data with Functions
    4. Manipulating SAS Date Values with Functions
    5. Modifying Character Values with Functions
    6. Modifying Numeric Values with Functions
    7. Nesting SAS Functions
    8. Chapter Quiz
  19. Chapter 15: Processing Data with DO Loops
    1. The Basics of DO Loops
    2. Constructing DO Loops
    3. Nesting DO Loops
    4. Iteratively Processing Observations from a Data Set
    5. Conditionally Executing DO Loops
    6. Using Conditional Clauses with the Iterative DO Statement
    7. Chapter Quiz
  20. Chapter 16: Processing Data with Arrays
    1. The Basics of SAS Arrays
    2. Creating One-Dimensional Arrays
    3. Expanding Your Use of Arrays
    4. Chapter Quiz
  21. Chapter 17: Reading Raw Data in Fixed Fields
    1. Identifying the Type of Numeric Data
    2. Using Formatted Input
    3. Using Informats
    4. Using Record Formats
    5. Chapter Quiz
  22. Chapter 18: Reading and Creating Raw Data in Free-Format
    1. Free-Format Data
    2. Reading Standard Data with List Input
    3. Specifying the Length of Character Variables
    4. Reading Free-Format Data with Non-Blank Delimiters and Missing Values
    5. Reading Nonstandard Data with List Input
    6. Creating Free-Format Data
    7. Write a Comma-Delimited File Using Formats
    8. Chapter Quiz
  23. Chapter 19: SAS Date and Time Values
    1. Reading Dates and Times with Informats
    2. Using Dates and Times in Calculations
    3. Displaying Date and Time Values with Formats
    4. Chapter Quiz
  24. Chapter 20: Creating a Single Observation from Multiple Raw Data Records
    1. A Word About Creating a Single Observation
    2. Using Line Pointer Controls
    3. Reading Multiple Records Sequentially
    4. Reading Multiple Records Non-Sequentially
    5. Combining Line Pointer Controls
    6. Chapter Quiz
  25. Chapter 21: Creating Multiple Observations from a Single Raw Data Record
    1. A Word About Creating Multiple Observations
    2. Reading Repeating Blocks of Data
    3. Reading the Same Number of Repeating Fields
    4. Reading a Varying Number of Repeating Fields
    5. Chapter Quiz
  26. Chapter 22: Conditioning Raw Data Files
    1. A Word About Conditioning Raw Data Files
    2. Creating One Observation per Detail Record
    3. Creating One Observation per Header Record
    4. Processing a DATA Step That Creates One Observation per Header Record
    5. Chapter Quiz
  27. Appendix 1: Quiz Answer Keys
    1. Chapter 2: Basic Concepts
    2. Chapter 3: Setting Up Your SAS Session
    3. Chapter 4: Identifying and Correcting Errors
    4. Chapter 5: Creating List Reports
    5. Chapter 6: Creating SAS Data Sets from External Files
    6. Chapter 7: Understanding DATA Step Processing
    7. Chapter 8: Creating and Applying User-Defined Formats
    8. Chapter 9: Producing Descriptive Statistics
    9. Chapter 10: Creating Output with ODS
    10. Chapter 11: Creating and Managing Variables
    11. Chapter 12: Reading SAS Data Sets
    12. Chapter 13: Combining SAS Data Sets
    13. Chapter 14: Using Functions to Manipulate Data
    14. Chapter 15: Processing Data with DO Loops
    15. Chapter 16: Processing Data with Arrays
    16. Chapter 17: Reading Raw Data in Fixed Fields
    17. Chapter 18: Reading and Creating Raw Data in Free-Format
    18. Chapter 19: SAS Date and Time Values
    19. Chapter 20: Creating a Single Observation from Multiple Raw Data Records
    20. Chapter 21: Creating Multiple Observations from a Single Raw Data Record
    21. Chapter 22: Conditioning Raw Data Files
  28. Index
  29. Additional Resources