http://crackman.net/?p=431
Given the SAS data sets:
WORK.MATH1A WORK.MATH1B
Name Fi Name Fi
——- – —— –
Lauren L Smith M
Patel A Lauren L
Chang Z Patel A
Hillier R
The following SAS program is submitted:
proc sql;
select *
from WORK.MATH1A
[_insert_set_operator_]
select *
from WORK.MATH1B
;
quit;
The following output is desired:
Name Fi
——- –
Lauren L
Patel A
Chang Z
Hillier R
Smith M
Lauren L
Patel A
Which SQL set operator completes the program
and generates the desired output?
A.
append corr
B.
union corr
C.
outer union corr
D.
intersect corr
答案及解释清参见博客:
http://crackman.net/?p=431