SAS Training

SAS Certified Adv Programmer 50 Questions (6)

Given the following SAS data sets One and Two:

One

Two

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.

b.

c.

d.

SAS Certified Adv Programmer 50 Questions (5)

Given the following SAS data sets One and Two:

One

Two

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.

b.

c.

d.

SAS Certified Adv Programmer 50 Questions (4)

Given the following SAS data sets One and Two:

One

Two

The following SAS program is submitted:

proc sql;
    select *
        from one
    except
    select *
        from two;
quit;

Which of the following reports is generated?

a.

b.

c.

d.

SAS Certified Adv Programmer 50 Questions (3)

Which one of the following programs is syntactically correct?

a.

proc sql;
    create table forecast as
        select a.*, b.sales
            from actual a, budget b
            where a.dept=b.dept and
                  a.month=b.month;
quit;

b.

proc sql;
    create table forecast as
        select a.* b.sales
            from actual as a, budget as b
            where a.dept=b.dept and
                  a.month=b.month;
quit;

c.

proc sql;
    create table forecast as
        select a.*, b.sales
            from actual as a, budget as b
            where dept=dept and
                  month=month;
quit;

d.

proc sql;
    create table forecast as
        select a.*, b.sales
            from actual, budget
            where a.dept=b.dept and
                  a.month=b.month;
quit;

SAS Certified Adv Programmer 50 Questions (2)

Given the following SAS data sets One and Two:

One

Two

The following SAS program is submitted:

proc sql;
    select one.*, sales
    from one right join two
    on one.year=two.year;
quit;

Which of the following reports is generated?

a.

b.

c.

d.