By admin | November 11, 2009

SAS Certified Adv Programmer 130 Questions (16)

Given the following SAS data sets ONE and TWO:

ONE 
YEAR QTR BUDGET 
2001 3   500 
2001 4   400
2002 1   700

TWO
YEAR QTR SALES
2001 4   300
2002 1   600

The following SAS program is submitted:

proc sql;
    select one.*, sales from one, two;
quit;

Which one of the following reports is generated?

A.

YEAR QTR BUDGET SALES
2001 4   400    300 
2002 1   700    600

B.

YEAR QTR BUDGET SALES
2001 3   500    .
2001 4   400    300
2002 1   700    600

C.

YEAR QTR BUDGET SALES
2001 3   500    300
2001 4   400    300
2002 1   700    600 

D.

YEAR QTR BUDGET SALES
2001 3   500    300
2001 4   400    300
2002 1   700    300
2001 3   500    600
2001 4   400    600
2002 1   700    600 

3 comments | Add One

  1. admin - 11/11/2009 at 1:20 pm

    D

  2. Consty - 02/19/2013 at 2:45 pm

    D: cross products

  3. Consty - 02/20/2013 at 2:24 pm

    D: because of the cross product

Leave a Comment

Leave a Reply

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