nerdexam
SAS_Institute

A00-211 · Question #138

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…

The correct answer is D. The data sets were not merged in the order by which they were sorted. See the full explanation below for the reasoning.

Question

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 rail to execute?

Options

  • AThe SORT procedures contain invalid syntax.
  • BThe merged data sets are not permanent SAS data sets.
  • CThe RUN statement was omitted alter each or the SORT procedures.
  • DThe data sets were not merged in the order by which they were sorted.

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    9% (2)
  • C
    4% (1)
  • D
    83% (19)

Community Discussion

No community discussion yet for this question.

Full A00-211 Practice