Given the data sets:
The following SAS program is submitted:
Which result set would be generated?
A00-212 Exam QuestionsBrowse all questions from this exam
A00-212 Exam - Question 8
Show AnswerHide Answer
Correct Answer: AC
The SQL query is performing a right join between two datasets on the 'Year' column. This means all rows from WORK.TWO will be included, along with matching rows from WORK.ONE. For connection, only the 2010 and 2011 years appear in WORK.TWO. In these years, there is data for profit as 100 for 2010 and 200 for 2011. Therefore, summing these profits gives 100 + 200 = 300.
Discussion
2 commentsnumanigerioOption: D
Apr 2, 2019I would say D. 400...it is right join, the 1 will be duplicate + once the second
SugarlipsOption: D
Nov 21, 2019Answer is D