SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 241:

  Given the raw data file EMPLOYEE:

  ----I----1 0---I----20---I----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 = `Ruth' then input idnum 10-11;

  else input age 7-8;

  run;

  What value does the variable IDNUM contain when the name of the employee is "Ruth"?

  A. 11

  B. 22

  C. 33

  D. (missing numeric value)

  Correct Answer: B

• Question 242:

  The following SAS program is submitted:

  data temp.x; set sasuser.y; run;

  What must be submitted prior to this SAS program for the program to execute successfully?

  A. A LIBNAME statement for the libref TEMP only must be submitted.

  B. A LIBNAME statement for the libref SASUSER only must be submitted.

  C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.

  D. No LIBNAME statement needs to be submitted.

  Correct Answer: A

• Question 243:

  The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable

  COUNTRYFEE with a format or 7.;

  The following SAS program is submitted:

  data history;

  format local fee country fee percent6.;

  set realestate;

  local fee = local fee / 100;

  country fee = country fee / 100;

  run;

  What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

  A. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.

  B. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.

  C. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.

  D. The data step fails execution; there is no format for LOCALFEE

  Correct Answer: C

• Question 244:

  The following SAS program is submitted:

  proc freq data = class;

  tables gender * age / ;

  run;

  The following report is created:

  The FREQ Procedure

  Table of gender by age

  Row Column

  Gender age Frequency Percent Percent Percent

  F 11 1 10.00 20.00 50.00

  12 2 20.00 40.00 40.00

  13 2 20.00 40.00 66.67

  Total 5 50.00 100.00

  M 11 1 10.00 20.00 50.00

  12 3 30.00 60.00 60,00

  13 1 10.00 20.00 33.33

  Total 5 50.00 100.00

  Total 11 2 20.00 100.00

  12 5 50.00 100.00

  13 3 30.00 100.00

  Total 10 100.00

  Which option correctly completes the program and creates the report?

  A. LIST

  B. NOCOLS

  C. CROSSLIST D. NOCROSSTAB

  Correct Answer: C

• Question 245:

  The following SAS program is submitted:

  data work.accounting; set work.department; length jobcode $ 12; jobcode='FAl'; run;

  The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?

  A. The length of the variable JOBCODE is 3.

  B. The length of the variable JOBCODE is 5.

  C. The length of the variable JOSBODE is 12.

  D. The program fails to execute due to errors.

  Correct Answer: B

• Question 246:

  Which ODS statement option terminates output being written to an HTML rile?

  A. END

  B. QUIT

  C. STOP

  D. CLOSE

  Correct Answer: D

• Question 247:

  The SAS data set PETS is sorted by the variables TYPE and BREED.

  The following SAS program is submitted:

  proc print data = pets;

  var type breed;

  sum number;

  run;

  What is the result?

  A. The SUM statement produces only a grand total of NUMBER.

  B. The SUM statement produces only subtotals of NUMBER for each value of TYPE.

  C. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.

  D. Nothing is produced by the SUM statement; the program fails to execute.

  Correct Answer: A

• Question 248:

  The following SAS program is submitted:

  data work.passengers;

  if OrigPassengers = . then'

  OrigPassengers = 100;

  TransPassengers = 100;

  OrigPassengers = .;

  TotalPassengers = sum (OrigPassengers, TransPassengers) +0;

  run;

  What is the value of the TOTALPASSENGERS variable in the output data set?

  A. 0

  B. 100

  C. 200

  D. (missing numeric value)

  Correct Answer: B

• Question 249:

  Given the SAS data set PRICES:

  PRICES Prodid price producttype sales returns K125 5.10 NETWORK 15 2 B132S 2.34 HARDWARE 300 10 R18KY2 1.29 SOFTWARE 25 5 3KL8BY 6.37 HARDWARE 125 15 DY65DW 5.60 HARDWARE 45 5 DGTY23 4.55 HARDWARE 67 2 The following SAS program is submitted: data hware inter cheap; set prices(keep = productype price); if producttype = `HARDWARE' then output hware; else if producttype = `NETWORK' then output inter; if price le 5.00; run; if producttype = `HARDWARE' then output hware; else if producttype = `NETWORK' then output inter; if price le 5.00; run;

  How many observations does the HWARE data set contain?

  A. 0

  B. 2

  C. 3

  D. 4

  Correct Answer: D

• Question 250:

  The following SAS program is submitted:

  

  How many observations are written to the WORK.SALES data set?

  A. 0

  B. 1

  C. 5

  D. 60

  Correct Answer: B