SAS BASE Q11. merge(by - sort)

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.

 

 

Answer: D

# 문제 풀이

 - 데이터셋은 fname 변수에 대해 descending(내림차순) 정렬인데, merge 구문에서는 fname 변수에 대해 오름차순 정렬을 했기 때문에 오류가 남.

 - 데이터셋에서 descending을 빼고 오름차순 정렬을 하거나, merge 구문에서 descending을 넣어줘야 함.