SASInstitute SAS Institute Systems Certification A00-212 Questions & Answers

• Question 171:

  Which of the following is true about the COMPRESS=YES data set option?

  A. It is most effective with numeric data that represents large numeric values

  B. It is most effective with character data that contains patterns, rather than simple repetitions

  C. It uses the Ross Data Compression method to compress numeric data

  D. It is most effective with character data that contains repeated characters

  Correct Answer: D

• Question 172:

  Given the SAS data sets ONE and TWO:

  

  The following SAS program is submitted:

  Proc sql;

  Select two.*,budget from one two on one.year=two.year,

  Quit;

  The following output is desired:

  

  Which JOIN operator completes the program and generates the desired output?

  A. FULL JOIN

  B. INNER JOIN

  C. LEFT JOIN

  D. RIGHT JOIN

  Correct Answer: A

• Question 173:

  Which one of the following options displays the value of a macro variable in the SAS log?

  A. MACRO

  B. SOURCE

  C. SOURCE2

  D. SYMBOLGEN

  Correct Answer: D

• Question 174:

  Given the SAS data sets:

  

  The SAS program is submitted:

  

  What output will be produced?

  A. Name

  Lauren

  Smith

  Patel

  Farmer

  Chang

  Hiller

  B. Name

  Chang

  Chang

  Lauren

  C. Name

  Patel

  Chang

  D. Name

  Lauren

  Patel

  Chang

  Chang

  Correct Answer: A

• Question 175:

  The following SAS program is submitted:

  data temp;

  length 1 b 3 x;

  infile 'file reference';

  input a b x;

  run;

  What is the result?

  A. The data set TEMP is not created because variables A and B have invalid lengths

  B. The data set TEMP is created, but variable X is not created

  C. The data set TEMP is not created because variable A has an invalid length

  D. The data set TEMP is created and variable X has a length of 8

  Correct Answer: C

• Question 176:

  Which one of the following is true regarding the KEEP statement?

  A. The KEEP statement is available in both the DATA and the PROC steps.

  B. The KEEP statement selects the variables read from the input data set(s).

  C. The KEEP statement applies to all data sets created within the same DATA step.

  D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.

  Correct Answer: C

• Question 177:

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

  

  Which program will result in the identical report?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

  Reference: http://www2.sas.com/proceedings/sugi31/030-31.pdf

• Question 178:

  What is the purpose of the SASFILE statement?

  A. It requests that SAS data set be opened and loaded into SAS memory one page at a time

  B. It requests that a SAS data set the opened and loaded into SAS memory one variable at a time

  C. It requests that a SAS data set be opened and loaded into SAS memory one observation at a time

  D. It requests that a SAS data set be opened and loaded into SAS memory in its entirety

  Correct Answer: D

• Question 179:

  The following SAS program is submitted:

  %let test=one;

  %let one=two;

  %let two=three;

  %let three=last;

  %put what displays is andandandandandtest;

  What is the written to the SAS log?

  A. What displays is three

  B. What displays is two

  C. What displays is one

  D. What displays is last

  Correct Answer: B

• Question 180:

  This item will ask you to provide a segment of missing code.

  Given the input data set shown on the left and the output data set shown on the right:

  

  In the text below, enter the code that will complete the program to produce the output set shown above on the right.

  Case is ignored and standard SAS syntax rules apply.

  Correct Answer: N