SAS PRACTICE EXAM QUESTIONS
AND ANSWERS
For observation 16, what is the value of VAR3? Enter your numeric answer in the
space below: - answer- Answer: 80136
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;
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;
How many observations (rows) are in results.match08? - answer- Answer: 1200
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many variables (columns) are in results.match08? - answer- Answer: 117
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many observations (rows) are in results.nomatch08? - answer- Answer: 2
, SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many variables (columns) are in results.nomatch08?
Enter your numeric answer in the space below:
Save your program as program08.sas in folder C:\cert\programs before continuing
with the next project. - answer- Answer: 5
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
What is the maximum salary that is less than $500,000? Enter your numeric answer
in the space below (Round your answer to the nearest integer)
What is the value of year when the above salary occurs? Enter your numeric answer
in the space below.
Save your program as program12.sas in folder C:\cert\programs before continuing
with the next project. - answer- Answer 1: 498737. (498736 also scored as correct).
Answer 2: 2027
SAS code that could be used to solve this project:
data results.output12; set cert.input12; do until (salary gt 500000);
salary=salary*1.0565; year+1; output; end; run;proc print data=results.output12; run;
What is the value of Chdate for observation 52? - answer- Answer: 30DEC1992
SAS code that could be used to solve this project:
data results.output13; set cert.input13; Chdate=put(date1,date9.);
num1=input(Charnum,dollar7.); run;proc print data=results.output13 (firstobs=52
obs=52); run;
What is the average (mean) of the num1 variable for the entire data set?
AND ANSWERS
For observation 16, what is the value of VAR3? Enter your numeric answer in the
space below: - answer- Answer: 80136
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;
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;
How many observations (rows) are in results.match08? - answer- Answer: 1200
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many variables (columns) are in results.match08? - answer- Answer: 117
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many observations (rows) are in results.nomatch08? - answer- Answer: 2
, SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
How many variables (columns) are in results.nomatch08?
Enter your numeric answer in the space below:
Save your program as program08.sas in folder C:\cert\programs before continuing
with the next project. - answer- Answer: 5
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a; by ID; run;proc sort
data=cert.input08b out=work.input08b; by ID; run;data results.match08
results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by
ID; if a and b then output results.match08; else output results.nomatch08; run;proc
contents data=results.match08; run;proc contents data=results.nomatch08; run;
What is the maximum salary that is less than $500,000? Enter your numeric answer
in the space below (Round your answer to the nearest integer)
What is the value of year when the above salary occurs? Enter your numeric answer
in the space below.
Save your program as program12.sas in folder C:\cert\programs before continuing
with the next project. - answer- Answer 1: 498737. (498736 also scored as correct).
Answer 2: 2027
SAS code that could be used to solve this project:
data results.output12; set cert.input12; do until (salary gt 500000);
salary=salary*1.0565; year+1; output; end; run;proc print data=results.output12; run;
What is the value of Chdate for observation 52? - answer- Answer: 30DEC1992
SAS code that could be used to solve this project:
data results.output13; set cert.input13; Chdate=put(date1,date9.);
num1=input(Charnum,dollar7.); run;proc print data=results.output13 (firstobs=52
obs=52); run;
What is the average (mean) of the num1 variable for the entire data set?
