SAS Certified Professional Prep Guide
eBook - ePub

SAS Certified Professional Prep Guide

Advanced Programming Using SAS 9.4

Share book
430 pages
ePUB (mobile friendly)
Available on iOS & Android
eBook - ePub

SAS Certified Professional Prep Guide

Advanced Programming Using SAS 9.4

Book details
Book preview
Table of contents

About This Book

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)

Frequently asked questions
How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is SAS Certified Professional Prep Guide an online PDF/ePUB?
Yes, you can access SAS Certified Professional Prep Guide by in PDF and/or ePUB format, as well as other popular books in Computer Science & Computer Science General. We have over one million books available in our catalogue for you to explore.


SAS Institute
Last updated: October 16, 2019



PROC SQL is the SAS implementation of Structured Query Language (SQL). SQL is a standardized language that is widely used to retrieve and update data in tables and in views that are based on those tables.
The following table compares terms that are used in data processing, SAS, and SQL.
This book uses all of these terms.
Data Processing
SAS data set
table or view
PROC SQL can often be used as an alternative to other SAS procedures or the DATA step. Use PROC SQL for tasks such as these:
  • retrieve data from and manipulate SAS tables
  • add or modify data values in a table
  • add, modify, or drop columns in a table
  • create tables and views
  • join multiple tables (when they contain columns with the same name)
  • generate reports


The SQL procedure is initiated with a PROC SQL statement. You can use multiple statements within a PROC SQL step. Each statement defines a process and is executed immediately. Each statement must end with a semicolon. The SQL procedure is terminated with a QUIT statement.
Syntax, SQL procedure:
PROC SQL <options>;
Last updated: October 16, 2019


A Brief Overview

The SELECT statement retrieves and displays data. It consists of a SELECT clause and several optional clauses that can be used within the SELECT statement. Each clause begins with a keyword and is followed by one or more components. The optional clauses name the input data set, subset, group, or sort the data.
A PROC SQL step that contains one or more SELECT statements is referred to as a PROC SQL query. The SELECT statement is only one of several statements that can be used with PROC SQL.

SELECT Statement Syntax

The SELECT statement is the primary tool of PROC SQL. Using the SELECT statement, you can identify, manipulate, and retrieve columns of data from one or more tables and views. The SELECT statement must contain a SELECT clause and a FROM clause, both of which are required in a PROC SQL query.
Syntax, SELECT statement:
PROC SQL <options>;
SELECT column-1 <,...column-n>
FROM input-table
<WHERE clause>
<GROUP BY clause>
<HAVING clause>
<ORDER BY clause>
When you construct a SELECT statement, you must specify the clauses in the following order:
  • The SELECT clause selects columns.
  • The FROM clause selects one or more source tables or views.
  • The WHERE clause enables you to filter your data.
  • The GROUP BY clause enables you to process data in groups.
  • The HAVING clause works with the GROUP BY clause to filter grouped results.
  • The ORDER BY clause specifies the order of the rows.

Example: Selecting Columns

To specify which columns to display in a query, write a SELECT clause. After the keyword SELECT, list one or more column names and separate the column names with commas. The SELECT clause specifies existing columns and can create columns. The existing columns are already stored in a table.
The following SELECT clause specifies the columns EmpID, JobCode, Salary, and bonus. The columns EmpID, JobCode, and Salary are existing columns. The column named Bonus is a new column. The column alias appears as a column heading in the output and matches the case that you used in the SELECT clause.

Table of contents

Citation styles for SAS Certified Professional Prep Guide
APA 6 Citation
[author missing]. (2019). SAS Certified Professional Prep Guide ([edition unavailable]). SAS Institute. Retrieved from (Original work published 2019)
Chicago Citation
[author missing]. (2019) 2019. SAS Certified Professional Prep Guide. [Edition unavailable]. SAS Institute.
Harvard Citation
[author missing] (2019) SAS Certified Professional Prep Guide. [edition unavailable]. SAS Institute. Available at: (Accessed: 14 October 2022).
MLA 7 Citation
[author missing]. SAS Certified Professional Prep Guide. [edition unavailable]. SAS Institute, 2019. Web. 14 Oct. 2022.