Which one of the following SQL programs creates an equivalent SAS data set THREE?

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; create table three as select * from one outer union corr select * from two; quit;
B . proc sql; create table three as select * from one outer union select * from two; quit;
C . proc sql; create table three as select * from one outer union select * quit;
D . proc sql; create table three as select * from one union corr select * from two; quit;

View Answer

Answer: A