SASInstitute SAS Institute Systems Certification A00-212 Questions & Answers

• Question 11:

  The following SAS program is submitted:

  %let value=9;

  %let add=5;

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

  What is the value of the macro variable NEWVAL?

  A. null

  B. 2

  C. 1

  D. 1.8

  Correct Answer: C

• Question 12:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.

  B. The WHERE statement selects observations before they are brought into the PDV.

  C. The subsetting IF statement works on observations before they are read into the PDV.

  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

  Correct Answer: B

• Question 13:

  Given the following SAS data set ONE:

  ONE

  LEVEL AGE

  1 10

  2 20

  3 20

  2 10

  1 10

  2 30

  3 10

  2 20

  3 30

  1 10

  The following SAS program is submitted:

  proc sql;

  select level, max(age) as MAX

  from one

  group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE 2 20 3 20

  B. LEVEL AGE 2 30 3 30

  C. LEVEL MAX 2 20 3 30

  D. LEVEL MAX 2 30 3 30

  Correct Answer: D

• Question 14:

  Given the SAS data sets shown on the left, the SAS program on the right is submitted.

  

  What will be the result when this program is executed?

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 15:

  In the data step merge, the BY variables in all data sets must have the same:

  A. Name and length

  B. Name, type, and length

  C. Name and type

  D. Name

  Correct Answer: B

  Reference: http://www2.sas.com/proceedings/sugi28/098-28.pdf

• Question 16:

  Given the data sets: The following SAS program is submitted:

  

  

  Which result set would be generated?

  A. 100

  B. 200

  C. 300

  D. 400

  Correct Answer: A

• Question 17:

  Which MACRO option is responsible for this partial SAS log?

  

  A. MAUTOLOCDISPLAY

  B. MLOGIC

  C. MPRINTNEST

  D. MPRINT

  Correct Answer: B

  Reference:

  http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a00 1066200.htm

• Question 18:

  Given the SAS data sets:

  

  A SAS program is submitted and the following is written to SAS to:

  

  What would allow the program to successfully execute without errors?

  A. Qualify the column names with the table names.

  B. Replace the 104 with: Where EMPLOYEE.Name = Any (Select names separated with `,' From WORK.NEWEMPLOYEE Where Salary > 40000);

  C. Replace the where clause with: Where EMPLOYEE.Name = (Select Names delimited with `,' From WORK.NEWEMPLOYEE Where Salary > 40000);

  D. Replace the equal sign with In operator.

  Correct Answer: B

• Question 19:

  The following SAS program is submitted:

  data new (bufnp=4);

  set old(bufno=4);

  run;

  Why are the BUFNO options used?

  A. To reduce the number I/O operations

  B. To reduce network traffic

  C. To reduce memory usage

  D. To reduce the amount of data read

  Correct Answer: A

• Question 20:

  The following SAS program is submitted:

  data temp;

  array points{3,2}_temporary_ (10,20,30,40,50,60);

  score = points{2,1}

  run;

  Which one of the following is the value of the variable SCORE in the data set TEMP?

  A. 10

  B. 20

  C. 30

  D. 40

  Correct Answer: C