如果是full join的话应该包含所有的row啊，为什么one里的2003没有了呢。
而且重复的year也应该是两列啊。多谢啦！
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 the program and generates the desired output?
A. left join B. right join C. full join D. outer join
扫码加好友，拉您进群
全部版块
我的主页
收藏
