By admin | November 18, 2009

SAS Certified Adv Programmer 130 Questions (18)

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 where one.year = two.year;
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

One comment | Add One

  1. admin - 11/18/2009 at 12:16 pm

    C

Leave a Comment

Leave a Reply

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