Which JOIN operator completes the program and generates the desired output?

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Proc sql;

Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year, Quit;

The following output is desired:

Which JOIN operator completes the program and generates the desired output?
A . FULL JOIN
B . INNER JOIN
C . LEFT JOIN
D . RIGHT JOIN

Answer: A

Latest A00-212 Practice Questions with 184 Q&As

Updated Study Material | Instant Download | Detailed Answers and Explanations

Subscribe
Notify of
guest
0 Comments