SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 121:

  The following SAS program is submitted:

  %let name = Patel's Restaurant;

  Which one of the following statements avoids problems associated with the unbalanced quotation mark?

  A. %let name = Patel%'s Restaurant;

  B. %let name = %str(Patel's Restaurant);

  C. %let name = Patel%str(')s Restaurant;

  D. %let name = %str(Patel%'s Restaurant);

  Correct Answer: D

• Question 122:

  Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

  A. It temporarily compresses observations in a SAS data set.

  B. It allows users to update the same SAS data set concurrently.

  C. It allows new observations to be inserted wherever enough free space exists.

  D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.

  Correct Answer: C

• Question 123:

  Given the following SAS data set ONE:

  ONE

  DIVISION SALES

  A 1234

  A 3654

  B 5678

  The following SAS program is submitted:

  data _null_;

  set one;

  by division;

  if first.division then

  call symput('mfirst',sales);

  if last.division then

  call symput('mlast',sales);

  run;

  Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

  A. null

  B. 1234

  C. 3654

  D. 5678

  Correct Answer: D

• Question 124:

  The following SAS program is submitted: data temp:

  array points { 2,3 } (10,15,20,25,30,35);

  run;

  What impact does the ARRAY statement have in the program Data vector (PDV)?

  A. The variables named POINTS10, POINTS15,POINTS20,POINTS25,POINTS30, POINTS35 are created in the PDV

  B. No variables are created in the PDV

  C. The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV

  D. The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV

  Correct Answer: C

• Question 125:

  The following SAS program is submitted:

  %let var = chicago, 1;

  data a;

  var = 'new york, 2';

  newvar = %scan(andvar,2,%str());

  run;

  Which one of the following explains why the program fails to execute?

  A. The %STR() is invalid syntax.

  B. The %SCAN function does not exist.

  C. The %SCAN function has too many arguments.

  D. The macro variable VAR does not get created properly.

  Correct Answer: C

• Question 126:

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda

  B. a is cat

  C. a is pig

  D. a is bird

  Correct Answer: B

• Question 127:

  The following SAS program is submitted:

  

  The current system date macro variable is 30JUL2013. Which output will be written to the log by the program?

  A. In two years it will be: 2014+1

  B. Error: Required operator not found in expression in two years it will be: 2013+12+1

  C. In two years it will be: 2013+1+1+1

  D. In two years it will be: 2014+1+1

  Correct Answer: D

• Question 128:

  Which macro statement would remove the macro variable mv_Info from the symbol table?

  A. %symercase Mv_Info;

  B. %symdel and Mv_Info;

  C. %symdel Mv_Info;

  D. %mdelete and Mv_Info;

  Correct Answer: C

• Question 129:

  Which SAS produce can be used to report Page Size?

  A. PRINT Procedure

  B. CATALOG Procedure

  C. REPORT Procedure

  D. CONTENTS Procedure

  Correct Answer: C

• Question 130:

  The following SAS program is submitted: data new (bufsize = 6144 bufno = 4); set old; run;

  Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?

  A. BUFSIZE= specifies the size of the input buffer in bytes; BUFNO= specifies the number of input buffers.

  B. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers.

  C. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of input buffers.

  D. BUFSIZE= specifies the size of the output buffer in kilobytes; BUFNO= specifies the number of output buffers.

  Correct Answer: B