SAS Certified Adv Programmer 50 Questions (1)
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 and
one.qtr=two.qtr;
quit;
Which of the following reports is generated?
a.
| Year | Qtr | Budget | Sales |
| 2001 | 3 | 500 | 300 |
| 2002 | 1 | 700 | 600 |
b.
| Year | Qtr | Budget | Sales |
| 2001 | 4 | 400 | 300 |
| 2002 | 1 | 700 | 600 |
c.
| Year | Qtr | Budget | Sales |
| 2001 | 3 | 500 | . |
| 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 |
2 Comments »
B
B, double cross product