SAS_Institute
A00-201 · Question #111
70: 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…
The correct answer is A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber. See the full explanation below for the reasoning.
Question
70: 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 order by EmployeeIDNumber.
- CCOMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLL.SORTED is created in sorted order by EmployeeIDNumber.
- DCOMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
How the community answered
(25 responses)- A80% (20)
- B12% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.