SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 151:

  Given the AIRPLANES data set

  AlRPLANES TYPE MPG

  F-18 105

  C-130 25

  Harrier 75

  A-6 110

  The following SAS program is submitted:

  data gt100;

  set airplanes(keep = type mpg load);

  load = mpg * 150;

  run;

  The program fails to execute due to syntax errors.

  What is the cause of the syntax error?

  A. MPG is not a numeric variable.
  B. LOAD is not a variable in the data set GT100.
  C. LOAD is not variable in the data set AIRPLANES.
  D. LOAD must be defined prior to the SET statement.
  C. LOAD is not variable in the data set AIRPLANES.

• Question 152:

  The following SAS program is submitted:

  data stats;

  set revenue;

  array weekly{5} mon tue wed thu fri;

  total = weekly{i} * .25;

  output;

  end;

  run;

  Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

  A. do i = 1 to 5;
  B. do weekly{i} = 1 to 5;
  C. do i = mon tue wed thu fri;
  D. A DO loop cannot be used because the variables referenced do not end in a digit.
  A. do i = 1 to 5;

• Question 153:

  The following SAS program is submitted:

  

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

  A. Hemingway
  B. Hemingwa
  C. ' ' (a missing value)
  D. The program contains errors. No variables are created.
  B. Hemingwa

• Question 154:

  Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

  A. libname sasdata 'SAS-data-library'; data sasdata.mydata; copy mydata; run;
  B. libname sasdata 'SAS-data-library'; data sasdata.mydata; keep mydata; run;
  C. libname sasdata 'SAS-data-library'; data sasdata.mydata; save mydata; run;
  D. libname sasdata 'SAS-data-library'; data sasdata.mydata; set mydata; run;
  D. libname sasdata 'SAS-data-library'; data sasdata.mydata; set mydata; run;

• Question 155:

  The following SAS program is submitted:

  data work.total;

  set work.salary(keep = department wagerate);

  by department;

  if first.department

  then payroll = 0;

  payroll + wagerate;

  if last.department;

  run;

  The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.

  Which statement is true?

  A. The BY statement in the DATA step causes a syntax error.
  B. The statement payroll + wagerate; in the DATA step causes a syntax error.
  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
  D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.
  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

• Question 156:

  Given the SAS data set WORK.P2000:

  

  And the SAS data set WORK.P2008:

  

  The following output is desired:

  

  Which SAS program correctly combines the data?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 157:

  The following output is created by the FREQUENCY procedure:

  

  1 23

  3 23

  1 77

  Which TABLES statement was used to completed the following program that produced the output?

  proc freq data=sales; <_insert_code_> run;

  A. tables region product;
  B. tables region,product
  C. tables region/product;
  D. tables region*product;
  D. tables region*product;

• Question 158:

  Which statement describes a characteristic of the SAS automatic variable _ERROR_?

  A. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
  B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
  C. The _ERROR_ variable can be used in expressions in the DATA step.
  D. The _ERROR_ variable contains the number of the observation that caused the data error.
  C. The _ERROR_ variable can be used in expressions in the DATA step.

• Question 159:

  The following SAS program is submitted:

  data combine; prefix='505'; middle='6465 `; end='09090'; ; run;

  Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

  A. total = cat('-', prefix, middle, end);
  B. total = catx('-', prefix, middle, end);
  C. total = prefix !!'-'!! middle ``!!'-'!! end;
  D. total = prefix!!'-'!! left(middle)!!'-'!! end;
  B. total = catx('-', prefix, middle, end);

• Question 160:

  Given the SAS data set QTR 1_REVENUE:

  destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254 YYZ 82174

  The following SAS program is submitted:

  proc sort data = qtr1_revenue; by destination descending revenue; run;

  What is the first observation in the output data set?

  A. destination revenue FRA 62129
  B. destination revenue FRA 75962
  C. destination revenue YYZ 53634
  D. destination revenue YYZ 82174
  B. destination revenue FRA 75962