SAS Training

SAS Certified Adv Programmer 130 Questions (25)

Given the following SAS data sets ONE and TWO:

ONE 
NUM CHAR1 
1   A
2   B
4   D

TWO 
NUM CHAR2
2   X
3   Y
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; 

    
    	

2 comments | Add One

Leave a Comment