Another practice exam question:
-------------------------
The dataset Cars it not sorted, but is grouped by make.
data dups uniquedata(index=(make/unique));
set cars (keep=make);
by make notsorted;
if first.make then output uniquedata;
else output dups;
run;
When you compile and execute the program above, what is the result?
A) Uniquedata contains a distinct list of Make in sequenced order.
B) Uniquedata contains a distinct list of Make but not necessarily in sequenced order
C) Uniquedata contains a distinct list of Make but not necessarily in sequenced order, the index was built.
D) The dataset DUPS is also indexed on Make.
--------------------
I answered C, since i couldn't find anything wrong with the code, but the answer is B. Is there any reason this index couldn't
be created?
Does the notsorted option somehow cancel the index?