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
Login
0 Comments