By admin | December 2, 2009

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

  1. admin - 12/2/2009 at 10:07 am

    A

  2. Consty - 02/20/2013 at 4:09 pm

    A: outer union corr concatenates results from two queries by selecting all rows and overlaying same columns

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *