A00-212 Exam Questions and Answers | Exam-Dumps (Page: 6)

QUESTION: 26

What is the purpose of the SASFILE statement?

It requests that SAS data set be opened and loaded into SAS memory one page at a time
It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
It requests that a SAS data set be opened and loaded into SAS memory in its entirety

Answer(s): D

Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2

The following SAS program is submitted:

Proc sql;
Select name from CLASS1
<insert SQL set operator here>
select name from CLASS;
quit;
The following output is desired
NAME
Chang
Chang
Lauren

Which SQL set operator completes the program and generates the desired output?

UNION ALL
EXCEPT ALL
INTERSECT ALL
OUTER UNION ALL

Answer(s): B

Reveal Solution Next Question

QUESTION: 28

The following SAS program is submitted:

data new (bufnp=4);
set old(bufno=4);
run;

Why are the BUFNO options used?

To reduce the number I/O operations
To reduce network traffic
To reduce memory usage
To reduce the amount of data read

Answer(s): A

Reveal Solution Next Question

QUESTION: 29

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?

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

Answer(s): A

Reveal Solution Next Question

QUESTION: 30

The SAS data set ONE contains fifty million observations and contains the variable
PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

data two;
Set one;
Where totrev>1000;
Totrev=sum(price*quantity);
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
data two;
Set one;
totrev=sum(price*quantity);
where totrev>1000;
totcost=sum(fixed,variable);
profit=sum(totrev,-totcost);
run;
data two;
Set one;
Totrev=sum(price*quantity);
If totrev>1000;
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
data two;
Set one;
Totrev = sum(price*quantity);
Totcost= sum(fixed,variable);
If totrev>1000;
Profit=sum(totrev,-totcost);
Run;

Answer(s): C

Reveal Solution Next Question

SAS Institute A00-212 Exam (page: 6)
SAS Institute SAS Advanced Programming Exam for SAS 9
Updated on: 09-Feb-2026

QUESTION: 26

QUESTION: 27

QUESTION: 28

QUESTION: 29

QUESTION: 30

SAS Institute A00-212 Exam (page: 6) SAS Institute SAS Advanced Programming Exam for SAS 9 Updated on: 09-Feb-2026

QUESTION: 26

QUESTION: 27

QUESTION: 28

QUESTION: 29

QUESTION: 30

SAS Institute A00-212 Exam (page: 6)
SAS Institute SAS Advanced Programming Exam for SAS 9
Updated on: 09-Feb-2026