SAS Certified Specialist: Base Programming Using SAS 9.4 — Question 3

The following SAS program is submitted:
proc sort data=SASUSER.VISIT out=PSORT;
by code descending date cost;
run;
Which statement is true regarding the submitted program?

Answer options

• A. The descending option applies to the variable CODE.
• B. The variable CODE is sorted by ascending order.
• C. The PSORT data set is stored in the SASUSER library.
• D. The descending option applies to the DATE and COST variables.

Correct answer: B

Explanation

The correct answer is B because the program does not apply the descending option to CODE, meaning it is sorted in ascending order by default. The descending option only affects DATE and COST, making option D true, but not relevant to CODE. Therefore, A and C are also incorrect regarding the sorting behavior.