By admin | August 10, 2009

SAS Certified Adv Programmer 50 Questions (5)

Given the following SAS data sets One and Two:

One

Num Var1
1 A
1 A
2 B
3 C

Two

Num Var2
1 A
4 Y
4 Z

The following SAS program is submitted:

proc sql;
    select *
        from one
    intersect all
    select *
        from two;
quit;

Which of the following reports is generated?

a.

Num
1

b.

Num
1
2

c.

Num Var1
1 A

d.

Num Var1
1 A
1 A

3 comments | Add One

  1. admin - 08/10/2009 at 9:28 pm

    C

  2. Blaiso - 05/31/2013 at 9:03 pm

    D. the ALL includes unique and non unique rows

  3. NDfan - 08/28/2014 at 2:58 pm

    Isn’t it d, because the ‘intersect ALL’
    does not drop duplicates?

Leave a Comment

Leave a Reply

Your email address will not be published.