Question 1
Which PROC SQL join returns only rows that have matching keys in both tables?
Correct Answer:
INNER JOIN
Question 2
Before using a MERGE statement with BY in a DATA step, what must be true of both input datasets?
Correct Answer:
They must be sorted (or indexed) by the BY variables
Question 3
What is the purpose of FIRST.byvar and LAST.byvar automatic variables in BY-group processing?
Correct Answer:
They flag the first and last observation within each BY group, enabling group-level logic
Question 4
Which PROC reshapes a SAS dataset from wide to long (or long to wide) format?
Correct Answer:
PROC TRANSPOSE
Question 5
In PROC SORT, what does the NODUPKEY option do?
Correct Answer:
Removes observations with duplicate values of the BY variables only
Question 1
Exam overview

About this Exam

Prepare with the SAS Data Scientist Practice Questions - SAS Certified Professional Data Scientist Exam practice quiz. This question bank includes 100 questions covering proc, model, data, viya, and fits. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

SAS Data Scientist Practice Questions - SAS Certified Professional Data Scientist Exam

This practice set contains 100 questions from the matching question bank and focuses on proc, model, data, viya, and fits. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions