SASInstitute SAS Institute Systems Certification A00-212 Questions & Answers

• Question 181:

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

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

  

  

  In the text box in the program above, complete the program so that it will properly use the macro variable to select the corresponding cities. Case is ignored and standard SAS syntax rules apply.

  Correct Answer: North Carolina

• Question 182:

  The question will ask you to provide a segment of missing code. The following SAS program is submitted:

  

  The text box above, complete the %PUT statement to produce the following log output:

  Case is ignored and standard SAS syntax rules apply.

  Correct Answer: _sample_

• Question 183:

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

  Given data sets ONE and TWO with the same variables, the following SAS program is submitted:

  

  In the text below, complete the following program so that it will produce the same results as the above program:

  

  Case is ignored and standard SAS syntax rules apply.

  Correct Answer: CORR

• Question 184:

  Given a data set with the following characteristics:

  50000 observations 200 character variables

  In the text below, enter the compression option that will provide the most compression Case is ignored and standard SAS syntax rules apply.

  Correct Answer: CHAR

  The YES or CHAR setting for the COMPRESS= option uses the RLE compression algorithm. RLE compresses observations by reducing repeated consecutive characters (including blanks) to two-byte or three-byte representations. Therefore, RLE is most often useful for character data that contains repeated blanks. The YES or CHAR setting is also good for compressing numeric data in which most of the values are zero