By admin | August 11, 2009

SAS Certified Adv Programmer 50 Questions (6)

Given the following SAS data sets One and Two:

One

Num Product
1 Computer
2 Printer
3 Monitor
4 Keyboard
5 Modem

Two

Num Product
1 Portable
5 External

The following SAS program is submitted:

proc sql;
    select product
        from one
        where exists
            (select *
                from two
                where one.num=two.num);

Which of the following reports is generated?

a.

Product
Computer
Modem

b.

Product
Computer
Printer

c.

Product
Printer
Monitor
Keyboard

d.

Product
Computer
Printer
Monitor
Keyboard
Modem

One comment | Add One

  1. admin - 08/11/2009 at 3:17 pm

    A

Leave a Comment

Leave a Reply

Your email address will not be published.