55. Given the SAS data sets ONE and TWO: ONETWO YEAR QTR BUDGETYEARQTRSALES 20013 50020014 300 20014 40020021 600 20031 350 The following SAS program is submitted: proc sql; select two.*, budget from one two on one.year = two.year; quit; The following output is desired: YEAR QTR BUDGET SALES 2001 4 300 500 2001 4 300 400 2002 1 600 . . . . 350 Which JOIN operator completes the program and generates the desired output?
A.LEFT JOIN
B.RIGHT JOIN
C.FULL JOIN
D.INNER JOIN
Answer: C
56. Given the SAS data sets CLASS1 and CLASS2: CLASS1CLASS2 NAME COURSENAME COURSE Lauren MATH1Smith MATH2 Patel MATH1Farmer MATH2 Chang MATH1Patel MATH2 Hillier MATH2 The following SAS program is submitted: proc sql; select name from CLASS1 select name from CLASS2; quit; The following output is desired: NAME Chang Lauren Which SQL set operator completes the program and generates the desired output?
A.UNION
B.EXCEPT
C.INTERSECT
D.OUTER UNION CORR
Answer: B
