SAS Certified Professional Prep Guide

SAS Certified Professional Prep Guide

by SAS Institute
Released October 2019
Publisher(s): SAS Institute
ISBN: 9781642954692

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

The official guide by the SAS Global Certification Program, SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 prepares you to take the new SAS 9.4 Advanced Programming Performance-Based Exam.

New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers to the chapter quizzes and solutions to the sample scenarios in the workbook are included. You will also find links to exam objectives, practice exams, and other resources such as the Base SAS Glossary and a list of practice data sets. Major topics include SQL processing, SAS macro language processing, and advanced SAS programming techniques.

All exam topics are covered in the following chapters:

SQL Processing with SAS

  • PROC SQL Fundamentals
  • Creating and Managing Tables
  • Joining Tables Using PROC SQL
  • Joining Tables Using Set Operators
  • Using Subqueries
  • Advanced SQL Techniques

SAS Macro Language Processing

  • Creating and Using Macro Variables
  • Storing and Processing Text
  • Working with Macro Programs
  • Advanced Macro Techniques

Advanced SAS Programming Techniques

  • Defining and Processing Arrays
  • Processing Data Using Hash Objects
  • Using SAS Utility Procedures
  • Using Advanced Functions

Practice Programming Scenarios (Workbook)

Table of contents

  1. Title Page
  2. Copyright
  3. Using Sample Data
  4. Accessibility Features of the Prep Guide
  5. How to Prepare for the Exam
    1. Chapter 1: PROC SQL Fundamentals
      1. PROC SQL Basics
      2. The PROC SQL SELECT Statement
      3. The FROM Clause
      4. The WHERE Clause
      5. The GROUP BY Clause
      6. The HAVING Clause
      7. The ORDER BY Clause
      8. PROC SQL Options
      9. Validating Query Syntax
      10. Quiz
      11. End Notes
    2. Chapter 2: Creating and Managing Tables
      1. The CREATE TABLE Statement
      2. Using the LIKE Clause
      3. Using the AS Keyword
      4. The INSERT Statement
      5. The DESCRIBE TABLE Statement
      6. Using Dictionary Tables
      7. Chapter Quiz
    3. Chapter 3: Joining Tables Using PROC SQL
      1. Understanding Joins
      2. Generating a Cartesian Product
      3. Using Inner Joins
      4. Using Natural Joins
      5. Using Outer Joins
      6. Comparing SQL Joins and DATA Step Match-Merges
      7. Quiz
    4. Chapter 4: Joining Tables Using Set Operators
      1. Understanding Set Operators
      2. Using the EXCEPT Set Operator
      3. Using the INTERSECT Set Operator
      4. Using the UNION Set Operator
      5. Using the OUTER UNION Set Operator
      6. Quiz
    5. Chapter 5: Using Subqueries
      1. Subsetting Data Using Subqueries
      2. Creating and Managing Views Using PROC SQL
      3. Quiz
    6. Chapter 6: Advanced SQL Techniques
      1. Creating Data-Driven Macro Variables with PROC SQL
      2. Accessing DBMS Data with SAS/ACCESS
      3. The FedSQL Procedure
      4. Quiz
    1. Chapter 7: Creating and Using Macro Variables
      1. Introducing Macro Variables
      2. The SAS Macro Facility
      3. Using Macro Variables
      4. Troubleshooting Macro Variable References
      5. Delimiting Macro Variable References
      6. Quiz
    2. Chapter 8: Storing and Processing Text
      1. Processing Text with Macro Functions
      2. Using SAS Macro Functions to Manipulate Character Strings
      3. Using SAS Functions with Macro Variables
      4. Using SAS Macro Functions to Mask Special Characters
      5. Creating Macro Variables during PROC SQL Step Execution
      6. Creating Macro Variables during DATA Step Execution
      7. Referencing Macro Variables Indirectly
      8. Quiz
    3. Chapter 9: Working with Macro Programs
      1. Defining and Calling a Macro
      2. Passing Information into a Macro Using Parameters
      3. Controlling Variable Scope
      4. Debugging Macros
      5. Conditional Processing
      6. Iterative Processing
      7. Quiz
    4. Chapter 10: Advanced Macro Techniques
      1. Storing Macro Definitions in External Files
      2. Understanding Session Compiled Macros
      3. Using the Autocall Facility
      4. Data-Driven Macro Calls
      5. Quiz
    1. Chapter 11: Defining and Processing Arrays
      1. Defining and Referencing One-Dimensional Arrays
      2. Expanding Your Use of One-Dimensional Arrays
      3. Defining and Referencing Two-Dimensional Arrays
      4. Quiz
    2. Chapter 12: Processing Data Using Hash Objects
      1. Declaring Hash Objects
      2. Defining Hash Objects
      3. Finding Key Values in a Hash Object
      4. Writing a Hash Object to a Table
      5. Hash Object Processing
      6. Using Hash Iterator Objects
      7. Quiz
    3. Chapter 13: Using SAS Utility Procedures
      1. Creating Picture Formats with the FORMAT Procedure
      2. Creating Functions with PROC FCMP
      3. Quiz
    4. Chapter 14: Using Advanced Functions
      1. Using a Variety of Advanced Functions
      2. Performing Pattern Matching with Perl Regular Expressions
      3. Quiz
    1. Chapter 15: Practice Programming Scenarios
      1. Differences between the Workbook and Certification Exam
      2. Scenario 1
      3. Scenario 2
      4. Scenario 3
      5. Scenario 4
      6. Scenario 5
      7. Scenario 6
      8. Scenario 7
      9. Scenario 8
      10. Scenario 9
      11. Scenario 10
    1. Chapter 16: Chapter Quiz Answer Keys
      1. Chapter 1: PROC SQL Fundamentals
      2. Chapter 2: Creating and Managing Tables
      3. Chapter 3: Joining Tables Using PROC SQL
      4. Chapter 4: Joining Tables Using Set Operators
      5. Chapter 5: Using Subqueries
      6. Chapter 6: Advanced SQL Techniques
      7. Chapter 7: Creating and Using Macro Variables
      8. Chapter 8: Storing and Processing Text
      9. Chapter 9: Working with Macro Programs
      10. Chapter 10: Advanced Macro Techniques
      11. Chapter 11: Defining and Processing Arrays
      12. Chapter 12: Processing Data Using Hash Objects
      13. Chapter 13: Using SAS Utility Procedures
      14. Chapter 14: Using Advanced Functions
    2. Chapter 17: Programming Scenario Solutions
      1. Scenario 1
      2. Scenario 2
      3. Scenario 3
      4. Scenario 4
      5. Scenario 5
      6. Scenario 6
      7. Scenario 7
      8. Scenario 8
      9. Scenario 9
      10. Scenario 10
  11. Recommended Reading
  12. Index
  13. Additional Resources

Product information

  • Title: SAS Certified Professional Prep Guide
  • Author(s): SAS Institute
  • Release date: October 2019
  • Publisher(s): SAS Institute
  • ISBN: 9781642954692