SASInstitute SAS Advanced Programming Exam for SAS 9

QUESTION NO: 1
The following SAS program is submitted:

What is written to the SAS log?

A. WARNING: Apparent symbolic reference ROOT2 not resolved B. &Name2 C. MATH1 D. MATH3

Correct Answer: D

QUESTION NO: 2
The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;
Which one of the following contains all the names of the columns created by the
TRANSPOSE procedure?

A. new, X, Y, and _COL1_ B. X, Y, Z, and W C. _NAME_, X, and Y D. new, X, and COL1

Correct Answer: D

QUESTION NO: 3
This question will ask you to provide a segment of missing code.
The following SAS program submitted:

Which segment of code will successfully run an in-line view?

A. Option A B. Option C C. Option D D. Option B

Correct Answer: C

QUESTION NO: 4
When is it appropriate to create indexes on a SAS data set for efficient processing?

A. if the SAS data set file page count is less than three pages B. if small subsets of data are often retrieved C. if the data are often used for BY group processing D. if the key variable has very few unique values

Correct Answer: B

QUESTION NO: 5
The following SAS program is submitted:
options reuse=YES;
data sasuser RealEstate(compress=CHAR);
set sasuser houses;
run;
What is the effect of the REUSE=YES SAS system option?

A. It tracks and recycles free space B. It allows a permanently stored SAS data set to be replaced C. It allows users to access the same SAS data set concurrently D. It allows updates in place

Correct Answer: A

QUESTION NO: 6
The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?

A. temporary disk usage B. I/O and CPU usage C. CPU usage only D. I/O usage only

Correct Answer: A

QUESTION NO: 7
Given the data sets shown on the left, the SAS program shown on the right is submitted.

What will be output by the program?

A. Average of employment 7 B. Average of Employment 5 C. Average of Employment 6 D. ERROR: Subquery evaluated to more than one row

Correct Answer: B

QUESTION NO: 8
Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing
REVENUE?

A. order by 1, 3 B. orderby product, revenue desc C. order by 1, 3 desc D. order by product, desc revenue

Correct Answer: C

QUESTION NO: 9
The following SAS program is submitted:
% let first=yourname;
% let last=first;
% put &&&last;
What is written to the SAS Log?

A. First B. Yourname C. &&First D. &yourname

Correct Answer: B

QUESTION NO: 10
The following SAS program is submitted:
<insert statement here>;
% let development = ontime;
proc print data = sasuser.highway;
title "For &dept";
title2 "This project was completed &development";
run;
Which one of the following statements completes the above and resolves title1 to "For
research&development"?

A. %let dept = %str(research&development); B. %let dept = %str(research%&development); C. %let dept = %nrstr(research&development); D. %let dept = %nrstr(research%&development);

Correct Answer: C

QUESTION NO: 11
Which one of the following statements is true regarding a SAS DATA step view?

A. It allows write capabilities. B. It contains data and a descriptor portion. C. It contains a partially compiled DATA step. D. It contains global statements.

Correct Answer: C

QUESTION NO: 12
In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

A. data three;
set one;
where char1 in ('new york' 'los angeles');
run; B. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit; C. data three;
set one;
if char1 in ('new york' 'los angeles');
run; D. data three;
set one;
set two key = char1;
run;

Correct Answer: D

QUESTION NO: 13
The following SAS program is submitted:

How will the variable be listed?

A. Weight Height Name Age B. Weight Height C. Name Age Weight Height D. Height Weight Name Age

Correct Answer: C

SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212 Exam Questions