QUESTION: 41

Given the SAS dataset ONE ONE
ONE
SALARY
200
205
523
The following SAS program is submitted
Proc sql;
Select * from one
<Insert Where expression here>;
quit;

The following output is desired:
SALARY
200
205
523

Which WHERE expression completes the program and generates the desired output?

Where salary is not
Where salary ne null
Where salary is not missing
Where salary ne missing

Answer(s): C

Reveal Solution Next Question

QUESTION: 42

At the start of a new SAS session; the following program is submitted:

%macro one;
data _null_;
call symput('proc','measn);
run;
proc &proc data=sashelp.class;
run;
%mend;
%one()

What is the result?

The marco variable PRCO is stored in the SAS catalog WORK.SASMACR
The program fails to execute because PROC is a reserved word
The macro variable PROC is stored in the local symbol table
The macro variable PROC is stored in the global symbol table

Answer(s): D

Reveal Solution Next Question

QUESTION: 43

The following SAS program is submitted:

%let value=9;
%let add=5;
%let newval=%eval(&value/&add);

What is the value of the macro variable NEWVAL?

null
2
1
1.8

Answer(s): C

Reveal Solution Next Question

QUESTION: 44

Given the non-indexed SAS data set TEMP:

TEMP
X Y
P 52
P 45
A 13
A 56
R 34
R 12
R 78

The following SAS program is submitted:
Proc print data=temp;
<insert By statement here?
Run;

Which by statement completes the program, create a listing report that is grouped by X and completes without errors?

X;
By X groupd;
By X notsorted;
By descending X;

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 11)

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44