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
Topics:
SAS Adv Questions |
1 Comment »
C