Sas Practice Exam Expected Questions With Verified Answers

SAS PRACTICE EXAM EXPECTED QUESTIONS WITH
VERIFIED ANSWERS

Question 1.
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently
ordered by Department.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
The correct answer is:
The values of the variable
Payroll represent the annual
total for each department in the WORK.SALARY data set.



Question 2.
The following SAS program is submitted:
proc means data=work.schools median; <insert statement(s) here> run;
Assume that Work.Schools has 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
The correct answer is: class location;






,Question 3.
What is the average of Y for Group=2?
Enter your numeric answer in the space below: (Round your answer to the nearest whole number.)
Save your program as program48.sas in folder C:\cert\programs before continuing with the next
project.

ANSWER
Answer: 703. (702 also
scored as correct.)
SAS code that could be used to solve this project:
data groups; set cert.input48; if upcase(cvar) in ('A','B','C','D','E','F','G') then group=1; else if
upcase(cvar) in ('H','I','J','K','L','M','N') then group=2; else group=3; new_y=input(y,7.3); *convert
to numeric; run;/* Calculate the average of X and Y by Group */ /*
What is the average of X and Y for Group 2? */proc
means data=groups mean maxdec=2; where group = 2;
class group; var x new_y; run;



Question 4.
For observation 16, what is the value of VAR20? Enter your numeric answer in the space below. Round
your answer to the nearest whole number.Save your program as program04.sas in C:\cert\programs
before continuing with the next project.

ANSWER
Answer: 3175. (3174 also
scored as correct.)
SAS code that could be used to solve this project:
data results.output04; set cert.input04; var3=round(var1,1)*round(var2,1); var20=sum(of
var12-var19); run;proc print data=results.output04
(obs=16 firstobs=16); var
var3 var20; run;






, Question 5.
A PROC PRINT report was created with the following title:
Asia Sports Vehicle SummaryAfter the PROC PRINT report is run, a programmer would next like to
produce a PROC FREQ report with the following title:Asia Sports Vehicle SummaryDistribution by
MakeWhich 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
The correct answer is:
title "Asia Sports Vehicle Summary";title2 "Distribution by Make";



Question 6.
What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number.

ANSWER
Answer: 47 (48 also scored as correct)
SAS code that could be used to solve this project:
data groups; set cert.input48; if upcase(cvar) in ('A','B','C','D','E','F','G') then group=1; else if
upcase(cvar) in ('H','I','J','K','L','M','N') then group=2; else group=3; new_y=input(y,7.3); *convert
to numeric; run;/* Calculate the average of X and Y by Group */ /*
What is the average of X and Y for Group 2? */proc
means data=groups mean maxdec=2; where group = 2;
class group; var x new_y; run;