[A00-211, Crambible] SAS Q11

SAS Base, A00-211 Crambible 

SAS 베이스 자격증 

QUESTION NO: 11

The following SAS program is submitted:

proc sort data = work.employee; 

by descending fname;

proc sort data = work.salary;
by descending fname;

data work.empdata;

merge work.employee work.salary;
by fname;
run;

Why does the program fail to execute?

A. The SORT procedures contain invalid syntax.
B. The merged data sets are not permanent SAS data sets.
C. The RUN statement was omitted alter each or the SORT procedures. 

D. The data sets were not merged in the order by which they were sorted.

프로그램 실행이 왜 실패했는지에 대해 이유를 찾는 문제입니다. 

work.employee와 work.salary 데이타 셋이 fname 변수를 기준으로 내림차숨으로 정렬이 되었습니다. merge 명령어를 통해 두 데이타셋을 by fname, 즉 오름차순으로 합치려고 하네요. 그래서 에러가 납니다. 

Answer: D