SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 131:

  Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

  A. ECHOVIEW option

  B. EXPANDVIEW option

  C. VALIDATE VIEW statement

  D. DESCRIBE VIEW statement

  Correct Answer: D

• Question 132:

  The following SAS ARRAY statement is submitted:

  array score{*} a4 - a10, a25 ;

  Which one of the following is the maximum number of elements stored?

  A. 3

  B. 7

  C. 8

  D. 11

  Correct Answer: C

• Question 133:

  Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?

  A. MODIFY and CHANGE statements

  B. RENAME statement only

  C. CHANGE statement only

  D. MODIFY and RENAME statements

  Correct Answer: C

• Question 134:

  The following SAS program is submitted:

  options mprint;

  %macro test(parm);

  proc andparm data = sashelp.prdsale;

  run;

  %mend;

  %test(print)

  What is the result of the MPRINT options?

  A. It has no effect in this example

  B. It writes the original program code inside the marco definition to the SAS log

  C. It writes macro execution messages to the SAS.log

  D. It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log

  Correct Answer: D

• Question 135:

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

  A. NODUP

  B. UNIQUE

  C. DISTINCT

  D. NODUPKEY

  Correct Answer: A

• Question 136:

  Given the data set SASHELP.CLASS:

  

  The following SAS program is submitted:

  

  The PROC steps execute successfully?

  A. PROC PRINT only

  B. PROC MEANS and PROC PRINT

  C. PROC MEANS only

  D. No PROC steps execute successfully

  Correct Answer: C

• Question 137:

  The following SAS program is submitted:

  %let value = 9;

  %let value2 = 5;

  %let newval = %eval(andvalue / andvalue2);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  A. 1

  B. 2

  C. 1.8

  D. null

  Correct Answer: A

• Question 138:

  Given the SAS data sets:

  

  The following SAS program is submitted:

  

  What data values are stored in data set WORK.COMBINE?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 139:

  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; run; Which WHERE statement successfully completes the program and produces a report?

  A. Where upcase(name)="upcase(andvalue)";

  B. Where upcase(name)="%upcase(andvalue)";

  C. Where upcase(name)=upcase(andvalue);

  D. Where upcase(name)=%upcase(andvalue);

  Correct Answer: B

• Question 140:

  The variable attributes of SAS data sets ONE and TWO are shown below:

  ONE TWO

  # Variable Type Len Pos # Variable Type Len Pos

  2 sales Num 8 8 2 budget Num 8 8

  1 year Num 8 0 3 sales Char 8 16

  1 year Num 8 0

  Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.

  The following SAS program is submitted:

  data three;

  merge one two;

  by year;

  run;

  Which one of the following is the result of the program execution?

  A. No messages are written to the SAS log.

  B. ERROR and WARNING messages are written to the SAS log.

  C. Data set THREE is created with two variables and 50 observations.

  D. Data set THREE is created with three variables and 100 observations.

  Correct Answer: B