Item 55 of 63 Mark item for review
Given the SAS data sets:
WORK.ONE WORK.TWO
Year Qtr Budget Year Qtr Sales
---- --- ------ ---- --- -----
2001 3 500 2001 4 300
2001 4 400 2002 1 600
2003 1 350
The following SAS program is submitted:
proc sql;
select
TWO.*,
budget
from
WORK.ONE
[_insert_join_operator_]
WORK.TWO
on ONE.Year=TWO.Year
;
quit;
The following output is desired:
Year Qtr Sales Budget
---- --- ----- ------
2001 4 300 500
2001 4 300 400
2002 1 600 .
. . . 350
Which join operator completes theprogram
and generates the desired output?
A.
left join
B.
right join
C.
full join
D.
outer join
C
完全是晕的,为什么b不对啊????