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?

Question

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?

Accepted Answer

C. FULL JOIN

Answer

A. LEFT JOIN

Answer

B. RIGHT JOIN

Answer

D. INNER JOIN

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…