Given the SAS data sets:
A SAS program is submitted and the following is written to SAS to:
What would allow the program to successfully execute without errors?
A00-212 Exam QuestionsBrowse all questions from this exam
A00-212 Exam - Question 7
Show AnswerHide Answer
Correct Answer: BD
The error occurs because the subquery returns multiple rows, but the main query expects a single value due to the use of the equal sign (=). To correct this, you should use the IN operator, which allows the main query to handle multiple values returned by the subquery. This change enables the program to successfully execute without errors.
Discussion
2 commentsnumanigerioOption: D
Apr 2, 2019I would say D. Replace the equal sign with In operator. The B is a strange mix with the INTO to define macro variables
SugarlipsOption: D
Nov 21, 2019yes, D