SAS Institute A00-231 Practice Exams
Last updated on Apr 06,2025 - Exam Code: A00-231
- Exam Name: SAS 9.4 Base Programming -- Performance-based exam
- Certification Provider: SAS Institute
- Latest update: Apr 06,2025
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- A . The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
- B . The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
- C . The _ERROR_ variable can be used in expressions in the DATA step.
- D . The _ERROR_ variable contains the number of the observation that caused the data error.
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- A . The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
- B . The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
- C . The _ERROR_ variable can be used in expressions in the DATA step.
- D . The _ERROR_ variable contains the number of the observation that caused the data error.
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
What describes the SAS automatic _ERROR_ variable?
- A . The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’
- B . The _ERROR variable maintains a count of the number of data errors.
- C . The _ERROR_ variable can be used in expressions or calculations in the DATA step.
- D . The ERROR_variable contains the number or the observation that caused the error.
The following SAS program is submitted:
data WORK.ONE;
Text=’Australia, US, Denmark’;
Pos=find (Text,’US’,’i’,5);
run;
What value will SAS assign to Pos?
- A . 0
- B . 1
- C . 2
- D . 12
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS ‘regions.xls’;
Which PROC PRINT step correctly displays the NORTH worksheet?
- A . proc print data=MYXLS.NORTH;run;
- B . proc print data=MYXLS.NORTH$;run;
- C . proc print data=MYXLS.’NORTH’e;run;
- D . proc print data=MYXLS.’NORTH$’n;run;
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS ‘regions.xls’;
Which PROC PRINT step correctly displays the NORTH worksheet?
- A . proc print data=MYXLS.NORTH;run;
- B . proc print data=MYXLS.NORTH$;run;
- C . proc print data=MYXLS.’NORTH’e;run;
- D . proc print data=MYXLS.’NORTH$’n;run;
Which statement correctly computes the average of four numerical values?
- A . average = mean(num1, num4);
- B . average = mean(num1 – num4);
- C . average = mean(ofnum1 – num4)
- D . average = mean(num1 num2 num3 num4);
The following SAS program is submitted:
data combine;
prefix=’505’;
middle=’6465 ‘;
end=’09090’;
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?
- A . total = cat(’-’, prefix, middle, end);
- B . total = catx(’-’, prefix, middle, end);
- C . total = prefix !!’-’!! middle ‘‘!!’-’!! end;
- D . total = prefix!!’-’!! left(middle)!!’-’!! end;
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
- A . A LIBNAME statement for the libref TEMP only must be submitted.
- B . A LIBNAME statement for the libref SASUSER only must be submitted.
- C . LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
- D . No LIBNAME statement needs to be submitted.