SAS Certified Adv Programmer 50 Questions (4)
Given the following SAS data sets One and Two:
One
| Num | Var1 |
| 1 | A |
| 1 | A |
| 2 | B |
| 3 | C |
Two
| Num | Var2 |
| 1 | A |
| 4 | Y |
| 4 | Z |
The following SAS program is submitted:
proc sql;
select *
from one
except
select *
from two;
quit;
Which of the following reports is generated?
a.
| Num |
| 2 |
| 3 |
b.
| Num | Var1 |
| 2 | B |
| 3 | C |
c.
| Num | Var1 |
| 1 | A |
| 2 | B |
| 3 | C |
d.
| Num | Var2 |
| 1 | A |
| 4 | Y |
| 4 | Z |
Topics:
SAS Adv Questions |
3 Comments »
B
B. unique rows from A that don`t exist on B
table one uses var1
table two uses var2
does it matter?