You are previewing SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition.
O'Reilly logo
SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition

Book Description

New and experienced SAS users who want to prepare for the Base Programming for SAS 9 exam will find the this book to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam.

Table of Contents

  1. Cover Page
  2. Copyright Page
  3. Contents
  4. About This Book
  5. Chapter 1: Base Programming
    1. Overview
    2. SAS Programs
    3. SAS Libraries
    4. Referencing SAS Files
    5. SAS Data Sets
    6. Using the Programming Workspace
    7. Chapter Summary
    8. Chapter Quiz
  6. Chapter 2: Referencing Files and Setting Options
    1. Overview
    2. Viewing SAS Libraries
    3. Specifying Results Formats
    4. Setting System Options
    5. Additional Features
    6. Chapter Summary
    7. Chapter Quiz
  7. Chapter 3: Editing and Debugging SAS Programs
    1. Overview
    2. Opening a Stored SAS Program
    3. Editing SAS Programs
    4. Clearing SAS Programming Windows
    5. Interpreting Error Messages
    6. Correcting Errors
    7. Resolving Common Problems
    8. Additional Features
    9. Chapter Summary
    10. Chapter Quiz
  8. Chapter 4: Creating List Reports
    1. Overview
    2. Creating a Basic Report
    3. Selecting Variables
    4. Identifying Observations
    5. Sorting Data
    6. Generating Column Totals
    7. Double Spacing LISTING Output
    8. Specifying Titles and Footnotes
    9. Assigning Descriptive Labels
    10. Formatting Data Values
    11. Using Permanently Assigned Labels and Formats
    12. Additional Features
    13. Chapter Summary
    14. Chapter Quiz
  9. Chapter 5: Creating SAS Data Sets from External Files
    1. Overview
    2. Raw Data Files
    3. Steps to Create a SAS Data Set from a Raw Data File
    4. Referencing a SAS Library
    5. Referencing a Raw Data File
    6. Writing a DATA Step Program
    7. Submitting the DATA Step Program
    8. Creating and Modifying Variables
    9. Subsetting Data
    10. Reading Instream Data
    11. Creating a Raw Data File
    12. Additional Features
    13. Reading Microsoft Excel Data
    14. LIBNAME Statement Options
    15. Creating Excel Worksheets
    16. The IMPORT Wizard
    17. Chapter Summary
    18. Chapter Quiz
  10. Chapter 6: Understanding DATA Step Processing
    1. Overview
    2. Writing Basic DATA Steps
    3. How SAS Processes Programs
    4. Compilation Phase
    5. Execution Phase
    6. Debugging a DATA Step
    7. Testing Your Programs
    8. Chapter Summary
    9. Chapter Quiz
  11. Chapter 7: Creating and Applying User-Defined Formats
    1. Overview
    2. Introduction to PROC FORMAT
    3. Defining a Unique Format
    4. Associating User-Defined Formats with Variables
    5. Chapter Summary
    6. Chapter Quiz
  12. Chapter 8: Producing Descriptive Statistics
    1. Overview
    2. Objectives
    3. Computing Statistics Using PROC MEANS
    4. Selecting Statistics
    5. Limiting Decimal Places
    6. Specifying Variables in PROC MEANS
    7. Group Processing Using the CLASS Statement
    8. Group Processing Using the BY Statement
    9. Creating a Summarized Data Set Using PROC MEANS
    10. Creating a Summarized Data Set Using PROC SUMMARY
    11. Producing Frequency Tables Using PROC FREQ
    12. Specifying Variables in PROC FREQ
    13. Creating Two-Way Tables
    14. Creating N-Way Tables
    15. Creating Tables in List Format
    16. Chapter Summary
    17. Chapter Quiz
  13. Chapter 9: Producing HTML Output
    1. Overview
    2. The Output Delivery System
    3. Opening and Closing ODS Destinations
    4. Creating HTML Output with Options
    5. Creating HTML Output with a Table of Contents
    6. Using Options to Specify Links and Paths
    7. Changing the Appearance of HTML Output
    8. Additional Features
    9. Chapter Summary
    10. Chapter Quiz
  14. Chapter 10: Creating and Managing Variables
    1. Overview
    2. Creating and Modifying Variables
    3. Assigning Values Conditionally
    4. Specifying Lengths for Variables
    5. Subsetting Data
    6. Assigning Permanent Labels and Formats
    7. Assigning Values Conditionally Using SELECT Groups
    8. Grouping Statements Using DO Groups
    9. Chapter Summary
    10. Chapter Quiz
  15. Chapter 11: Reading SAS Data Sets
    1. Overview
    2. Reading a Single Data Set
    3. Manipulating Data
    4. Using BY-Group Processing
    5. Detecting the End of a Data Set
    6. Additional Features
    7. Chapter Summary
    8. Chapter Quiz
  16. Chapter 12: Combining SAS Data Sets
    1. Overview
    2. One-to-One Merging
    3. Concatenating
    4. Appending
    5. Interleaving
    6. Match-Merging
    7. Match-Merge Processing
    8. Renaming Variables
    9. Excluding Unmatched Observations
    10. Selecting Variables
    11. Additional Features
    12. Chapter Summary
    13. Chapter Quiz
  17. Chapter 13: Transforming Data with SAS Functions
    1. Overview
    2. Understanding SAS Functions
    3. General Form of SAS Functions
    4. Converting Data with Functions
    5. Manipulating SAS Date Values with Functions
    6. Modifying Character Values with Functions
    7. Modifying Numeric Values with Functions
    8. Nesting SAS Functions
    9. Chapter Summary
    10. Chapter Quiz
  18. Chapter 14: Generating Data with DO Loops
    1. Overview
    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. Creating Samples
    8. Chapter Summary
    9. Chapter Quiz
  19. Chapter 15: Processing Variables with Arrays
    1. Overview
    2. Creating One-Dimensional Arrays
    3. Expanding Your Use of Arrays
    4. Additional Features
    5. Chapter Summary
    6. Chapter Quiz
  20. Chapter 16: Reading Raw Data in Fixed Fields
    1. Overview
    2. Review of Column Input
    3. Identifying Nonstandard Numeric Data
    4. Choosing an Input Style
    5. Using Formatted Input
    6. Using Informats
    7. Record Formats
    8. Chapter Summary
    9. Chapter Quiz
  21. Chapter 17: Reading Free-Format Data
    1. Overview
    2. Free-Format Data
    3. Using List Input
    4. Reading Missing Values
    5. Specifying the Length of Character Variables
    6. Modifying List Input
    7. Creating Free-Format Data
    8. Mixing Input Styles
    9. Additional Features
    10. Chapter Summary
    11. Chapter Quiz
  22. Chapter 18: Reading Date and Time Values
    1. Overview
    2. How SAS Stores Date Values
    3. How SAS Stores Time Values
    4. More about SAS Date and Time Values
    5. Reading Dates and Times with Informats
    6. Using Dates and Times in Calculations
    7. Using Date and Time Formats
    8. Chapter Summary
    9. Chapter Quiz
  23. Chapter 19: Creating a Single Observation from Multiple Records
    1. Overview
    2. Using Line Pointer Controls
    3. Reading Multiple Records Sequentially
    4. Reading Multiple Records Non-Sequentially
    5. Combining Line Pointer Controls
    6. Chapter Summary
    7. Chapter Quiz
  24. Chapter 20: Creating Multiple Observations from a Single Record
    1. Overview
    2. Reading Repeating Blocks of Data
    3. Reading the Same Number of Repeating Fields
    4. Reading a Varying Number of Repeating Fields
    5. Chapter Summary
    6. Chapter Quiz
  25. Chapter 21: Reading Hierarchical Files
    1. Overview
    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 Summary
    6. Chapter Quiz
  26. Appendix 1: Quiz Answer Keys
    1. Chapter 1: Base Programming
    2. Chapter 2: Referencing Files and Setting Options
    3. Chapter 3: Editing and Debugging SAS Programs
    4. Chapter 4: Creating List Reports
    5. Chapter 5: Creating SAS Data Sets from External Files
    6. Chapter 6: Understanding DATA Step Processing
    7. Chapter 7: Creating and Applying User-Defined Formats
    8. Chapter 8: Producing Descriptive Statistics
    9. Chapter 9: Producing HTML Output
    10. Chapter 10: Creating and Managing Variables
    11. Chapter 11: Reading SAS Data Sets
    12. Chapter 12: Combining SAS Data Sets
    13. Chapter 13: Transforming Data with SAS Functions
    14. Chapter 14: Generating Data with DO Loops
    15. Chapter 15: Processing Variables with Arrays
    16. Chapter 16: Reading Raw Data in Fixed Fields
    17. Chapter 17: Reading Free-Format Data
    18. Chapter 18: Reading Date and Time Values
    19. Chapter 19: Creating a Single Observation from Multiple Records
    20. Chapter 20: Creating Multiple Observations from a Single Record
    21. Chapter 21: Reading Hierarchical Files
  27. Glossary
  28. Index