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)