SAS Certification Prep Guide, 5th 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 a valuable resource that covers all of the objectives tested on the exam. Now in its fifth edition, the guide has been extensively updated and revised to streamline explanations.

Major topics include importing data, 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.

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. Accessing Your Practice Data
  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: Accessing Your Data
    1. SAS Libraries
    2. Viewing SAS Libraries
    3. Chapter Quiz
  8. Chapter 4: Creating SAS Data Sets
    1. Referencing an External Data File
    2. The IMPORT Procedure
    3. Reading and Verifying Data
    4. Using the Imported Data in a DATA Step
    5. Reading a Single SAS Data Set to Create Another
    6. Reading Microsoft Excel Data with the XLSX Engine
    7. Creating Excel Worksheets
    8. Writing Observations Explicitly
    9. Chapter Quiz
  9. Chapter 5: Identifying and Correcting SAS Language Errors
    1. Error Messages
    2. Correcting Common Errors
    3. Chapter Quiz
  10. Chapter 6: Creating Reports
    1. Creating a Basic Report
    2. Selecting Variables
    3. Identifying Observations
    4. Sorting Data
    5. Generating Column Totals
    6. Specifying Titles and Footnotes in Procedure Output
    7. Assigning Descriptive Labels
    8. Using Permanently Assigned Labels
    9. 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: BY-Group Processing
    1. Definitions
    2. Preprocessing Data
    3. FIRST. and LAST. DATA Step Variables
    4. Chapter Quiz
  13. Chapter 9: Creating and Managing Variables
    1. Creating Variables
    2. Modifying Variables
    3. Specifying Lengths for Variables
    4. Subsetting Data
    5. Chapter Quiz
  14. Chapter 10: 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. Match-Merging: Details
    6. Match-Merge Processing
    7. Renaming Variables
    8. Excluding Unmatched Observations
    9. Chapter Quiz
  15. Chapter 11: 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. Chapter Quiz
  16. Chapter 12: SAS Formats and Informats
    1. Applying SAS Formats and Informats
    2. The FORMAT Procedure
    3. Defining a Unique Format
    4. Associating User-Defined Formats with Variables
    5. Chapter Quiz
  17. Chapter 13: SAS Date, Time, and Datetime Values
    1. SAS Date and Time Values
    2. Reading Dates and Times with Informats
    3. Example: Using Dates and Times in Calculations
    4. Displaying Date and Time Values with Formats
    5. 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: Producing Descriptive Statistics
    1. The MEANS Procedure
    2. The FREQ Procedure
    3. Chapter Quiz
  20. Chapter 16: Creating Output
    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
  21. Appendix 1: Quiz Answer Keys
    1. Chapter 2: Basic Concepts
    2. Chapter 3: Accessing Your Data
    3. Chapter 4: Creating SAS Data Sets
    4. Chapter 5: Identifying and Correcting SAS Language Errors
    5. Chapter 6: Creating Reports
    6. Chapter 7: Understanding DATA Step Processing
    7. Chapter 8: BY-Group Processing
    8. Chapter 9: Creating and Managing Variables
    9. Chapter 10: Combining SAS Data Sets
    10. Chapter 11: Processing Data with DO Loops
    11. Chapter 12: SAS Formats and Informats
    12. Chapter 13: SAS Date, Time, and Datetime Values
    13. Chapter 14: Using Functions to Manipulate Data
    14. Chapter 15: Producing Descriptive Statistics
    15. Chapter 16: Creating Output
  22. Index
  23. Additional Resources

Product information

  • Title: SAS Certification Prep Guide, 5th Edition
  • Author(s): SAS Institute
  • Release date: September 2018
  • Publisher(s): SAS Institute
  • ISBN: 9781635269918