Free A00-212 Web TestEngine Demo

Q21 Single choice

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;

A00-212 Web TestEngine demo