[A00-211, Crambible] SAS Q26 - sort

SAS Base, A00-211 Crambible 

SAS 베이스 자격증 

QUESTION NO: 26

Given the SAS data set WORKAWARDS: 

WORK.AWARDS 

FNAME POINTS MONTH

Amy 2 4 

Amy 1 7 

Gerard 3 3 

Wang 3 3 

Wang 1 12 

Wang 1 8 

The following SAS program is submitted: 

proc sort data = work.awards; 

by descending fname points; 

run; 

How are the observations sorted?

A. ENAME POINTS MONTH 

    Wang 3 3 

    Wang 1 12 

    Wang 1 8 

    Gerard 3 3 

    Amy 2 4 

    Amy 1 7 

B. ENAME POINTS MONTH 

    Amy 2 4 

    Amy 1 7 

    Gerard 3 3 

    Wang 3 3 

    Wang 1 8 

    Wang 1 12 

C. ENAME POINTS MONTH 

    Wang 3 3 

    Wang 1 8 

    Wang 1 12 

    Gerard 3 3 

    Amy 2 4 

    Amy 1 7 

D. ENAME POINTS MONTH

    Wang 1 12 

    Wang 1 8 

    Wang 3 3 

    Gerard 3 3 

    Amy 1 7 

    Amy 2 4

by descending fname points; 라서 

fname에 대해 descending 즉, 내림차순으로 정렬한 뒤, 그 안에서의 points는 default 값인 ascending 즉, 오름차순으로 정렬하게 됩니다. 

Answer: D