SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 81:

  The following SAS program is submitted:

  data work.test;

  Author = `Christie, Agatha';

  First = substr(scan(author,2,' ,`),1, 1);

  run;

  Which one of the following is the value of the variable FIRST in the output data set?

  A. A

  B. C

  C. Agatha

  D. ``(missing character value)

  Correct Answer: A

• Question 82:

  The following SAS program is submitted:

  proc contents data = sasuser.airplanes; run;

  Which one of the following is produced as output?

  A. the data portion of every data set in the SASUSER library

  B. the data portion of the data set SASUSER.AIRPLANES only

  C. the descriptor portion of every data set in the SASUSER library

  D. the descriptor portion of the data set SASUSER AIRPLANES only

  Correct Answer: D

• Question 83:

  The following SAS program is submitted:

  data work.company; set work.dept1(keep = jobcode) work.dept2(rename (jcode = jobcode)); run;

  Which one of the following is the result?

  A. The variable JCODE is written to the output data set.

  B. The variable JOBCODE is written to the output data set.

  C. Neither variable JOODE nor JOBCODE is written to the output data set.

  D. The program fails to execute due to errors.

  Correct Answer: B

• Question 84:

  The SAS data set WORK.AWARDS is listed below:

  The following SAS program is submitted:

  proc sort data = work.awards;

  by descending fname points;

  run;

  Which one of the following represents how the observations are sorted?

  

  A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1

  B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1

  C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1

  D. Wang 1D.Wang 1 Wang 2 Wang 3 Gerard 3 Amy 1 Amy 2

  Correct Answer: D

  

• Question 85:

  Which one of the following statements is true regarding the SAS automatic _ERROR_ variable?

  A. The _ERROR_ variable contains the values `ON' or `OFF'.

  B. The _ERROR_ variable contains the values `TRUE' or `FALSE'.

  C. The _ERROR_ variable is automatically stored in the resulting SAS data set.

  D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

  Correct Answer: D

• Question 86:

  The following SASS program is submitted:

  data work.sales;

  do year = 1 to 5;

  do month = 1 to 12;

  x+ 1;

  end;

  run;

  Which one of the following represents how many observations are written to the WORK SALES data set?

  A. 0

  B. 1

  C. 5

  D. 60

  Correct Answer: B

• Question 87:

  The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".

  Which one of the following SAS programs temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?

  A. proc print data = sasuser.houses; label price = "Sale Price"; run;

  B. proc print data = sasuser.houses label; label price "Sale Price"; run;

  C. proc print data = sasuser.houses label; label price = "Sale Price"; run;

  D. proc print data = sasuser.houses label = "Sale Price"; run;

  Correct Answer: C

• Question 88:

  The following SAS program is submitted:

  data work.accounting; set work.dept1 work.dept2; run;

  A character variable named JOSCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOSCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORPK.DEPT2 data set.

  Which one of the following is the length of the variable JOBCODE in the output data set?

  A. 5

  B. 7

  C. 8

  D. 12

  Correct Answer: A

• Question 89:

  The contents or the raw data rile AMOUNT are listed below:

  ----|----10----|----20----|----30 $1,234

  The following SAS program is submitted:

  data test; infile `amount'; input@1 salary 6.; run;

  Which one of the following is the value or the SALARY variable?

  A. 1234

  B. 1,234

  C. $1,234

  D. . (missing numeric value)

  Correct Answer: D

• Question 90:

  The following SAS program is submitted:

  data work.pieces; do while (n It 6); n + 1; end; run;

  Which one of the following is the value of the variable N in the output data set?

  A. 4

  B. 5

  C. 6

  D. 7

  Correct Answer: C