SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4

  • 5h 23m
  • SAS Institute
  • SAS Institute
  • 2019

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)

In this Book

  • How to Prepare for the Exam
  • Using Sample Data
  • Accessibility Features of the Prep Guide
  • PROC SQL Fundamentals
  • Creating and Managing Tables
  • Joining Tables Using PROC SQL
  • Joining Tables Using Set Operators
  • Using Subqueries
  • Advanced SQL Techniques
  • Creating and Using Macro Variables
  • Storing and Processing Text
  • Working with Macro Programs
  • Advanced Macro Techniques
  • Defining and Processing Arrays
  • Processing Data Using Hash Objects
  • Using SAS Utility Procedures
  • Using Advanced Functions
  • Practice Programming Scenarios
  • Chapter Quiz Answer Keys
  • Programming Scenario Solutions
  • Recommended Reading
SHOW MORE
FREE ACCESS

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 117 users Rating 4.3 of 117 users (117)
Rating 4.7 of 139 users Rating 4.7 of 139 users (139)