Free A00-212 Exam Braindumps

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?

  1. Select salary, salary*.10 var=BONUS
  2. Select salary, salary*.10 label='BONUS'
  3. Select salary, salary *.10 column='BONUS'
  4. Select salary, salary*.10 name='BONUS'

Answer(s): B



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?

  1. By X notsorted;
  2. By X grouped;
  3. By Descending X;
  4. By X;

Answer(s): A



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?

  1. Where upcase(name)="upcase(&value)";
  2. Where upcase(name)="%upcase(&value)";
  3. Where upcase(name)=upcase(&value);
  4. Where upcase(name)=%upcase(&value);

Answer(s): B



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?

  1. ORDEREDBY=X
  2. GROUPBY=X
  3. SORTEDBY=X
  4. SORTSYNC=X

Answer(s): C






Post your Comments and Discuss SAS Institute A00-212 exam with other Community members:

A00-212 Discussions & Posts