nerdexam
SAS_Institute

A00-211 · Question #89

The following SAS program is submitted: libname company 'SAS-data-library'; proc sort data = company.payroll; by EmployeeIDNumber; run; Write access has been granted to the COMPANY library. Which…

The correct answer is A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber. See the full explanation below for the reasoning.

Question

The following SAS program is submitted:

libname company 'SAS-data-library'; proc sort data = company.payroll; by EmployeeIDNumber; run; Write access has been granted to the COMPANY library. Which one of the following represents how the observations are sorted?

Options

  • ACOMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
  • BCOMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted
  • CCOMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED
  • DCOMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set

How the community answered

(40 responses)
  • A
    75% (30)
  • B
    8% (3)
  • C
    13% (5)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full A00-211 Practice