SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 131:

  A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

  A. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;

  B. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;

  C. proc print data = sasuser.houses; where price lt 60000 and price gt 100000; run;

  D. proc print data = sasuser.houses; where price lt 60000 or where price gt 100000; run;

  Correct Answer: B

• Question 132:

  Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

  A. non-missing numeric variable values only

  B. missing numeric variable values and non-missing numeric variable values only

  C. non-missing character variables and non-missing numeric variable values only

  D. missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values

  Correct Answer: A

• Question 133:

  The following SAS program is submitted:

  proc sort data = sasuser.houses out = houses;

  by style;

  run;

  proc print data = houses;

  run;

  Click on the Exhibit button to view the report produced.

  style bedrooms baths price

  CONDO 2 1.5 80050

  3 2.5 79350

  4 2.5 127150

  2 2.0 110700 RANCH 2 1.0 64000

  3 3.0 86650

  3 1.0 89100

  1 1.0 34550 SPLIT 1 1.0 65850

  4 3.0 94450

  3 1.5 73650 TWOSTORY 4 3.0 107250

  2 1.0 55850

  2 1.0 69250

  4 2.5 102950

  A.

  id style;

  B.

  id style; var style bedrooms baths price;

  C.

  id style; by style; var bedrooms baths price;

  D.

  id style; by style; var style bedrooms baths price;

  Which of the following SAS statement(s) create(s) the report?

  Correct Answer: C

• Question 134:

  The following SAS program is submitted:

  proc means data = sasuser.houses std mean max;

  var sqfeet;

  run;

  Which one of the following is needed to display the standard deviation with only two decimal places?

  A. Add the option MAXDEC = 2 to the MEANS procedure statement.

  B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.

  C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.

  D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

  Correct Answer: A

• Question 135:

  Which one of the following SAS system options displays the time on a report?

  A. TIME

  B. DATE

  C. TODAY

  D. DATETIME

  Correct Answer: B

• Question 136:

  Which one of the following SAS system options prevents the page number from appearing on a report?

  A. NONUM

  B. NOPAGE

  C. NONUMBER

  D. NOPAGENUM

  Correct Answer: C

• Question 137:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 7;

  if amount = 5 then word = 'CAT';

  else if amount = 7 then word = 'DOG';

  else word = 'NONE!!!';

  amount = 5;

  run;

  Which one of the following represents the values of the AMOUNT and WORD variables?

  A. amount word 5 DOG

  B. amount word 5 CAT

  C. amount word 7 DOG

  D. amount word 7 ' ' (missing character value)

  Correct Answer: A

• Question 138:

  The following SAS program is submitted:

  libname sasdata 'SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = 'chem3'

  then description = 'Senior Chemist';

  else description = 'Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOBCODE

  CHEM3

  Which one of the following values does the variable DESCRIPTION contain?

  A. chem3

  B. Unknown

  C. Senior Chemist

  D. ' ' (missing character value)

  Correct Answer: B

• Question 139:

  The following SAS program is submitted:

  options pageno = 1;

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  The report created by the PRINT procedure step generates 5 pages of output.

  What is the page number on the first page of the report generated by the MEANS procedure step?

  B. 2

  C. 5

  D. 6

  Correct Answer: D

• Question 140:

  The contents of the raw data file EMPLOYEE are listed below:

  --------10-------20-------30 Ruth 39 11 Jose 32 22

  Sue 30 33

  John 40 44

  The following SAS program is submitted:

  data test;

  infile 'employee';

  input employee_name $ 1-4;

  if employee_name = 'Sue' then input age 7-8;

  else input idnum 10-11;

  run;

  Which one of the following values does the variable AGE contain when the name of the employee is

  "Sue"?

  A. 30

  B. 33

  C. 40

  D. . (missing numeric value)

  Correct Answer: C