sas A00-231 Exam Questions
Questions for the A00-231 were updated on : Nov 21 ,2025
Page 1 out of 3. Viewing questions 1-15 out of 36
Question 1
Assume thatWork.Ds1andWork.Ds2exist and the following SAS program is submitted:
How many PDF files are created? Select one:
- A. 1 PDF file with all the output combined
- B. 2 PDF files -- one file for each data set used
- C. 2 PDF files -- one for the PRINT output and one for the FREQ output
- D. 3 PDF files -- one per procedure request
Answer:
A
Question 2
The following SAS program is submitted:
Why does the program produce an error? Select one:
- A. The PAGENO option is invalid in the OPTIONS statement.
- B. The RUN statement is missing after the FORMAT procedure.
- C. The format name contains a period in the VALUE statement.
- D. The LABEL option is missing from the PROC PRINT statement.
Answer:
C
Question 3
A PROC PRINT report was created with the following title:
Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to
produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by
Make Which statement(s) would produce the new report titles?
Select one:
- A. title "Distribution by Make";
- B. title "Asia Sports Vehicle Summary"; title "Distribution by Make";
- C. title "Asia Sports Vehicle Summary"; title2 "Distribution by Make";
- D. title "Asia Sports Vehicle Summary"; subtitle "Distribution by Make";
Answer:
C
Question 4
The following SAS program is submitted:
proc means data=work.schools median;
<insert statement(s) here>
run;
Assume thatWork.Schoolshas two numeric variables and the following PROC MEANS report is
produced:
Which of the following SAS statements completes the program and creates the desired report? Select
one:
- A. by location;
- B. class location;
- C. group by location;
- D. by location; id location;
Answer:
B
Question 5
The following SAS program is submitted:
data work.test;
type='SQL';
if type='SAS' then description='SAS Program';
else description='other'; length description 8;
run;
What occurs when the program is submitted?
Select one:
- A. The variable Description is created as an 11-byte character variable and is assigned the value 'SAS program' in the DATA step.
- B. The variable Description is created as a 5-byte character variable and is assigned the value 'SAS P' in the DATA step.
- C. The variable Description is created as an 8-byte character variable and is assigned the value 'SAS Prog' in the DATA step.
- D. The variable Description is created as an 11-byte character variable and the DATA step fails due to errors.
Answer:
D
Question 6
The following SAS program is submitted:
What are the values for x and y in the output data set?
Select one:
- A. There is a syntax error: x and y are both set to missing.
- B. There is a syntax error: x=2, y is set to missing.
- C. There are no errors: x=2, y=200.
- D. There is a logic error: x=2, y=27.
Answer:
D
Question 7
Given the following data set:
Which type of statement was included as a component of a transpose procedure step to produce the
following data set?
Select one:
- A. CLASS
- B. ID
- C. IDLABEL
- D. VAR
Answer:
D
Question 8
The following SAS program is submitted:
Which output is correct?
- A. yearamount i qtr 2017 33637.50 65
- B. yearamount i qtr 2016 33637.50 65
- C. yearamount i qtr 2016 33637.50 55
- D. yearamount i qtr 2016 33637.50 64
Answer:
B
Question 9
The SAS data set named WORK.SALARY contains 10 observations for each department, and is
currently ordered byDepartment
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY(keep=Department MonthlyWageRate);
by Department;
if First.Department=1 then Payroll=0;
Payroll+(MonthlyWageRate*12);
if Last.Department=1; run;
Which statement is true? Select one:
- A. The BY statement in the DATA step causes a syntax error.
- B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
- C. The values of the variable Payroll represent the annual total for each department in the WORK.SALARY data set.
- D. The values of the variable Payroll represent an annual total for all values of MonthlyWageRate in the WORK.SALARY data set.
Answer:
C
Question 10
Variable Name would have a format of $CHAR15. in the new data set Work. Both. The LENGTH
statement only gives the variable Name a predefined maximum length. The correct answer is:
$CHAR15 Given the SAS data set WORK.ONE:
X Y Z
- - --
1 A 27
1 A 33
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
The following SAS program is submitted:
data WORK.TWO;
set WORK.ONE;
by X Y;
if First.Y; run; proc print data=WORK.TWO noobs;
run;
Which report is produced?
Select one:
- A. X Y Z -- -- -- 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91
- B. X Y Z -- -- -- 1 A 27 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91
- C. X Y Z -- -- -- 1 A 33 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91
- D. X Y Z -- -- -- 1 A 27 1 B 45 2 A 52 2 B 69 4 A 82 4 C 91
Answer:
B
Question 11
The variable Name in the data set Employeehas a $CHAR10. format. The variable Name in the data
set Sales has a $CHAR15. format. The following SAS program is submitted:
data both;
length name $ 20;
merge sales employee;
by id;
run;
What is the format for the variable Name in the data set Both?
Select one:
- A. $20
- B. $CHAR10
- C. $CHAR15
- D. $CHAR20
Answer:
C
Question 12
Which of the following SAS programs creates a variable named City with a value ofChicago?
Select one:
- A. data work.airport; AirportCode='ord'; if (AirportCode='ord') City='Chicago'; run;
- B. data work.airport; AirportCode='ORD'; if AirportCode='ORD' then City=Chicago; run;
- C. data work.airport; AirportCode='ORD'; if AirportCode='ORD'; then City='Chicago'; run;
- D. data work.airport; AirportCode='ORD'; if AirportCode='ORD' then City='Chicago'; run;
Answer:
B
Question 13
Given the following SAS data set WORK.TOYS:
Product Group Price
--------- ----------- -----
Cards Indoors 9.99
Marbles Indoors 8.99
Drum Instruments 12.99
Hula-Hoop Outdoors 12.99
Ball Outdoors 8.49
The following SAS program is submitted:
data WORK.GROUPS;
set WORK.TOYS;
if Group="Outdoors" then Price_Gp="C";
if Price ge 12.99 then Price_Gp="A";
else if Price ge 8.99 then Price_Gp="B";
run;
What will be the value of Price_Gp for Hula-Hoop and Ball? Select one:
- A. Hula-Hoop: 'A', Ball: ' ' (missing value)
- B. Hula-Hoop: 'A', Ball: 'C'
- C. Hula-Hoop: 'C', Ball: ' ' (missing value)
- D. Hula-Hoop: 'C', Ball: 'C'
Answer:
B
Question 14
Given the following SAS data set WORK.CLASS:
Name Gender Age
Anna F 23
Ben M 25
Bob M 21
Brian M 27
Edward M 26
Emma F 32
Joe M 34
Sam F 32
Tom M 24
The following program is submitted: data WORK.MALES WORK.FEMALES(drop=age); set
WORK.CLASS; drop gender; if Gender="M" then output WORK.MALES; else if Gender="F" then
output WORK.FEMALES; run; How many variables are in the data set WORK.MALES?
Select one:
- A. The program does not execute due to a syntax error.
- B. 1
- C. 2
- D. 3
Answer:
C
Question 15
What is the format for the variableNamein the data setBoth? Select one:
- A. no format defined
- B. $CHAR
- C. $CHAR10
- D. $CHAR15
Answer:
D