Pass with professional A00-211 actual quiz materials

What describes the SAS automatic _ERROR_ variable?

• A. The ERROR_variable contains the number or the observation that caused the error.
• B. The _ERROR_ variable contains the values 'TRUE' or 'FALSE.'
• C. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
• D. The _ERROR variable maintains a count of the number of data errors.

Which one of the following is true of the SUM statement in a SAS DATA step program?

• A. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
• B. It is not valid with the SET, MERGE and UPDATE statements.
• C. It adds the value of an expression to an accumulator variable and ignores missing values.
• D. It is only valid in conjunction with a SUM function.

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?

• A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
• B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
• C. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
• D. COMPANY.PAYROLL is stored in original order, and a new data set
  COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.

This question will ask you to provide a missing option. Given the following SAS program:

Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

• A. labelsplit = '*'
• B. wrap = '*'
• C. split = '*'
• D. label = '*'

Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO
IDNumber
Expenses
2542
100.00
3612
133.15
2198
234.34
2198
111.12
The following SAS program is submitted:
proc sort data = employee_info;
<insert BY statement here>
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

• A. by ascending Expenses IDNumber;
• B. by IDNumber Expenses;
• C. by Expenses IDNumber;
• D. by ascending IDNumber ascending Expenses;