QUESTION: 85

Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?

MPRINT
MLOGIC
MSOURCE
SOURCE2

Answer(s): A

Reveal Solution Next Question

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
----
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS
from one; quit;

Which one of the following represents the data values stored in the data set TWO?

CATEGORY EARNINGS
M 200
M 110
F 150
F 210
CATEGORY EARNINGS
M .
M 110
F 150
F 210
CATEGORY SALARY BONUS EARNINGS
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210
CATEGORY SALARY BONUS EARNINGS
M 200 . .
M 100 10 110
M 200 . 200
M 100 10 110
F 100 50 150
F 200 10 210

Answer(s): B

Reveal Solution Next Question

QUESTION: 87

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

NODUP
UNIQUE
DISTINCT
NODUPKEY

Answer(s): A

Reveal Solution Next Question

QUESTION: 88

The following SAS program is submitted:
data temp;
array points{3,2}_temporary_ (10,20,30,40,50,60);
score = points{2,1}
run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

10
20
30
40

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 23)

QUESTION: 85

QUESTION: 86

QUESTION: 87

QUESTION: 88

A00-212 Discussions & Posts