A00-202 Real Exam Prep DEMO

Question 4: Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A 2 X 2 B 3 Y 4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three; set one two; run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?
A. proc sql;D.proc sql;
create table three as
select *
from one
union corr
select *
from two;
quit;
B. proc sql;C.proc sql;
create table three as
select *
from one
union
select *
from two;
quit;
C. proc sql;
create table three as
select *
from one
outer union
select *
from two;
quit;
D. proc sql;
create table three as
select *
from one
outer union corr
select *
from two;
quit;
Correct Answer: D