SAS BASE Q38. 정렬 옵션

QUESTION NO: 38

Given the SAS data set EMPLOYEE INFO:

EMPLOYEE_INFO

 

The following SAS program is submitted:

proc sort data = employee_info;

<insert BY statement here>

run;

 

Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

 

A. by Expenses IDNumber;

B. by IDNumber Expenses;

C. by ascending Expenses IDNumber;

D. by ascending IDNumber ascending Expenses;

 

 

Answer: B

# 구문 설명

 - within : ~내에서

# 문제 풀이

 - 기본적으로 오름차순 정렬이며, 내림차순 정렬은 descending이다.

 - ascending 명령은 없다. 실행 시 error 발생