QUESTION: 33

Given has SAS dataset ONE:

The following SAS program is submitted:

The following output is desired:
Proc sql;
<insert SQL clause here>
from one;
quit;

Which SQL procedure clause completes the program and generates the desired output?

Select salary, salary*.10 var=BONUS
Select salary, salary*.10 label='BONUS'
Select salary, salary *.10 column='BONUS'
Select salary, salary*.10 name='BONUS'

Answer(s): B

Reveal Solution Next Question

QUESTION: 34

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, creates a listing report that is grouped by X and completes without errors?

By X notsorted;
By X grouped;
By Descending X;
By X;

Answer(s): A

Reveal Solution Next Question

QUESTION: 35

Given the data set SASHELP.CLASS

SASHELP.CLASS
NAME AGE
Mary 15
Philip 16
Robert 12
Ronald 15
The following SAS program is submitted
%let value = Philip;
proc print data =sashelp.class;
<insert Where statement here>
run;

Which WHERE statement successfully completes the program and produces a report?

Where upcase(name)="upcase(&value)";
Where upcase(name)="%upcase(&value)";
Where upcase(name)=upcase(&value);
Where upcase(name)=%upcase(&value);

Answer(s): B

Reveal Solution Next Question

QUESTION: 36

Following SAS program is submitted:

data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;

RAWDATA is a file reference to an external file that is ordered by the variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?

ORDEREDBY=X
GROUPBY=X
SORTEDBY=X
SORTSYNC=X

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps

QUESTION: 33

QUESTION: 34

QUESTION: 35

QUESTION: 36