SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 161:

  The following program is submitted: Why does the program fail?

  

  A. The PAGENO option is invalid in the OPTIONS statement.

  B. The RUN statement is missing after the FORMAT procedure.

  C. The format name contains a period in the VALUE statement.

  D. The LABEL option is missing from the PROC PRINT statement.

  Correct Answer: C

• Question 162:

  Given the SAS data set WORK.PRODUCTS:

  

  How many observations does the WORK.OUTDOOR data set contain?

  A. 1

  B. 2

  C. 3

  D. 6

  Correct Answer: B

• Question 163:

  Consider the following data step:

  

  In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

  A. X would get a value of 1.

  B. X would get a value of 3.

  C. X would retain its original value of missing.

  D. This step does not run because of syntax errors.

  Correct Answer: A

• Question 164:

  The following SAS program is submitted:

  data WORK.AUTHORS;

  array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');

  run;

  What is the value of the second variable in the dataset WORK.AUTHORS?

  A. Hemingway

  B. Hemingwa

  C. ' ' (a missing value)

  D. The program contains errors. No variables are created.

  Correct Answer: B

• Question 165:

  The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label

  of "Open Date".

  Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the

  output?

  A. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;

  B. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;

  C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;

  D. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;

  Correct Answer: B

• Question 166:

  Given the SAS data set WORK.ONE:

  

  And the SAS data set WORK.TWO:

  

  The following program is submitted: What is the first observation in the SAS data set WORK.BOTH?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 167:

  The following SAS program is submitted:

  data WORK.DATE_INFO;

  Day="01" ;

  Yr=1960 ;

  X=mdy(Day,01,Yr) ;

  run;

  What is the value of the variable X?

  A. the numeric value 0

  B. the character value "01011960"

  C. a missing value due to syntax errors

  D. the step will not compile because of the character argument in the mdy function.

  Correct Answer: A

• Question 168:

  The following SAS program is submitted:

  

  What will the data set WORK.TEST contain?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 169:

  The following SAS program is submitted:

  

  What is produced as output?

  A. A file named test.cvs that can only be opened in Excel.

  B. A text file named test.cvs that can be opened in Excel or in any text editor.

  C. A text file named test.cvs that can only be opened in a text editor.

  D. A file named test.cvs that can only be opened by SAS.

  Correct Answer: B

• Question 170:

  You're attempting to read a raw data file and you see the following messages displayed in the SAS Log: What does it mean?

  

  A. A compiler error, triggered by an invalid character for the variable Salary.

  B. An execution error, triggered by an invalid character for the variable Salary.

  C. The 1st of potentially many errors, this one occurring on the 4th observation.

  D. An error on the INPUT statement specification for reading the variable Salary.

  Correct Answer: B