SAS Institute A00-231 Practice Exams
Last updated on Mar 31,2025- Exam Code: A00-231
- Exam Name: SAS 9.4 Base Programming -- Performance-based exam
- Certification Provider: SAS Institute
- Latest update: Mar 31,2025
The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:
WORK.ONE
Num Char
—— ——
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=’1′;
run;
What is output?
- A . Num Char— —- 1 23
- B . Num Char— —- 1 231 77
- C . Num Char— —- 1 233 231 77
- D . No output is generated.
The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
- A . 2 temporary and 1 permanent SAS data sets are created
- B . 3 temporary and 2 permanent SAS data sets are created
- C . 2 temporary and 2 permanent SAS data sets are created
- D . there is an error and no new data sets are created
The following SAS program is submitted:
footnote1 ‘Sales Report for Last Month’;
footnote2 ‘Selected Products Only’;
footnote3 ‘All Regions’;
footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’;
run;
Which footnote(s) is/are displayed in the report?
- A . All Products
- B . Sales Report for Last Month All Products
- C . All Products All Regions All Figures in Thousands of Dollars
- D . Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
00100.00
Total10100.00
Which option correctly completes the program and creates the report?
- A . LIST
- B . NOCOLS
- C . CROSSLIST
- D . NOCROSSTAB
Given the raw data record in the file phone.txt:
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
- A . FullName=CATX(”,EmpFName,EmpLName);
- B . FullName=CAT(”,EmpFName,EmpLName);
- C . FullName=EmpFName!!EmpLName;
- D . FullName=EmpFName + EmpLName;
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS
NAME AGE
Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm ‘SAS data library’;
data students;
set perm. Students;
file ‘file specification’;
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
- A . —-I—-10—I—-20—I—- 30
Alfred 14
Alice 13
Barbara 13
Carol 14 - B . —- I—-10—I—-20—I—-30
Alfr14
Alic13
Barb13a
Carol 4 - C . —-I—-10—I—-20—I—-30
Alfr14ed
Alic130
Barb13ara
Caro141 - D . —-I—-10—I—-20—I—-30
Alfred14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
proc format
value score 1 – 50 = ‘Fail’
51 – 100 = ‘Pass’;
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
- A . Fail
- B . Pass
- C . 50.5
- D . . (missing numeric value)
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
- A . libname qtrdata ‘qtr1.xls’;
- B . libname ‘qtr1.xls’ sheets=3;
- C . libname jan feb mar ‘qtr1.xls’;
- D . libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,mar);
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A . The output contains only a list of the SAS data sets that are contained in the WORK library.
- B . The output displays only the contents of the SAS data sets that are contained in the WORK library.
- C . The output displays only the variables in the SAS data sets that are contained in the WORK library.
- D . The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.
Which program displays a listing of all data sets in the SASUSER library?
- A . proc contents lib = sasuser.all; run;
- B . proc contents data = sasuser.all; run;
- C . proc contents lib = sasuser._alI_; run;
- D . proc contents data = sasuser._all_; run;