SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 31:

  The following SAS program is submitted and reads 100 records from a raw data file:

  data work.total;

  infile 'file-specification' end = eof;

  input name $ salary;

  totsal + salary;

  run;

  Which one of the following IF statements writes the last observation to the output data set?

  A. if end = 0;
  B. if eof = 0;
  C. if end = 1;
  D. if eof = 1;
  D. if eof = 1;

• Question 32:

  The following SAS program is submitted:

  data work.january;

  set work.allmonths (keep = product month num_sold cost);

  if month = 'Jan' then output work.january;

  sales = cost * num_sold;

  keep = product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only
  B. PRODUCT, MONTH, NUM_SOLD and COST only
  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
  D. An incomplete output data set is created due to syntax errors.
  D. An incomplete output data set is created due to syntax errors.

• Question 33:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal);

  if insal and inemp;

  run;

  The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?

  B. 5
  C. 7
  D. 12
  A

• Question 34:

  Given the SAS data set EMPLOYEE INFO:

  EMPLOYEE_INFO IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12

  The following SAS program is submitted:

  proc sort data = employee_info; run;

  Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

  A. by Expenses IDNumber;
  B. by IDNumber Expenses;
  C. by ascending Expenses IDNumber;
  D. by ascending IDNumber ascending Expenses;
  B. by IDNumber Expenses;

• Question 35:

  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
  A. non-missing numeric variable values only

• Question 36:

  The following SAS program is submitted:

  data work.clients;

  calls = 6;

  do while (calls le 6);

  calls + 1;

  end;

  run;

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

  A. 4
  B. 5
  C. 6
  D. 7
  D. 7

• Question 37:

  The following SAS DATA step is submitted:

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

  The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.

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

  A. 5
  B. 8
  C. 12
  D. The length can not be determined as the program fails to execute due to errors.
  A. 5

• Question 38:

  After a SAS program is submitted, the following is written to the SAS log:

  

  What changes should be made to the KEEP statement to correct the errors in the LOG?

  A. keep=(Product Sales);
  B. keep Product, Sales;
  C. keep=Product, Sales;
  D. keep Product Sales;
  D. keep Product Sales;

• Question 39:

  The value 110700 is stored in a numeric variable named SALARY.

  Which FORMAT statement displays the value as $110,700.00 in a report?

  A. format salary comma11.2;
  B. format salary dollar8.2;
  C. format salary dollar11.2;
  D. format salary comma8.2 dollar8.2;
  C. format salary dollar11.2;

• Question 40:

  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?

  B. 2
  C. 3
  D. 4
  D. 4