SAS Advanced Programming for SAS 9 — Question 22

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

proc sort data=WORK.CHECK;
by Code;
run;
What describes the result of submitting SAS program?

Answer options

• A. The index on Code is updates
• B. The sort does not execute
• C. The index on Code is deleted
• D. The index on the Code unaffected

Correct answer: B

Explanation

The correct answer is B because when a dataset with an index is sorted, the index is not utilized, and thus the sort operation does not proceed. Options A and C are incorrect because the index is not updated or deleted during this process. Option D is also incorrect as the index is not utilized for the sort.