SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 101:

  Which one of the following SAS procedures displays the data portion of a SAS data set?

  A. PRINT

  B. FSLIST

  C. CONTENTS

  D. DATASETS

  Correct Answer: A

• Question 102:

  The following SAS program is submitted:

  data work.test;

  array agents{4} $ 12 sales1 - sales4;

  run;

  Which one of the following represents the variables that are contained in the output data set?

  A. SALES1, SALES2, SALES3, SALES4

  B. AGENTS1, AGENTS2, AGENTS3, AGENTS4

  C. None, the DATA step fails because the ARRAY statement can reference only numeric data.

  D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

  Correct Answer: A

• Question 103:

  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.

  Correct Answer: A

• Question 104:

  Which one of the following statements is true regarding the name of a SAS array?

  A. It is saved with the data set.

  B. It can be used in procedures.

  C. It exists only for the duration of the DATA step.

  D. It can be the same as the name of a variable in the data set.

  Correct Answer: C

• Question 105:

  The SAS data set WORK.AWARDS is listed below:

  fname points

  Amy 2

  Amy 1

  Gerard 3

  Wang 3

  Wang 1

  Wang 2

  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 1 Wang 2

  Wang 3

  Gerard 3

  Amy 1

  Amy 2

  Correct Answer: D

• Question 106:

  The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.

  The following SAS program is submitted:

  proc sort data = work.test out = work.testsorted;

  by name;

  run;

  Which one of the following is the result of the SAS program?

  A. The data set WORK.TEST is stored in ascending order by values of the NAME variable.

  B. The data set WORK.TEST is stored in descending order by values of the NAME variable.

  C. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.

  D. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.

  Correct Answer: C

• Question 107:

  The SAS data set EMPLOYEE_INFO is listed below:

  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 one of the following BY statements completes the program and sorts the data sequentially by

  descending expense values within each descending IDNUMBER value?

  A. by descending IDNumber Expenses;

  B. by (IDNumber Expenses) descending;

  C. by IDNumber descending Expenses descending;

  D. by descending IDNumber descending Expenses;

  Correct Answer: D

• Question 108:

  The following SAS program is submitted:

  libname company 'SAS-data-library';

  proc sort data = company.payroll;

  by EmployeeIDNumber;

  run;

  Write access has been granted to the COMPANY library.

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

  A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.

  B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.

  C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.

  D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber

  Correct Answer: A

• Question 109:

  The SAS data set named WORK.TEST is listed below:

  capacity airplanetype staff 150 Large 10

  Which one of the following SAS programs created this data set?

  A. data work.test; capacity = 150; if 100 le capacity le 200 then airplanetype = 'Large' and staff = 10; else airplanetype = 'Small' and staff = 5; run;

  B. data work.test;

  capacity = 150;

  if 100 le capacity le 200 then

  do;

  airplanetype = 'Large';

  staff = 10;

  end;

  else

  do;

  airplanetype = 'Small';

  staff = 5;

  end;

  run;

  C. data work.test; capacity = 150; if 100 le capacity le 200 then do; airplanetype = 'Large'; staff = 10; else do; airplanetype = 'Small'; staff = 5; end; run;

  D. data work.test; capacity = 150; if 100 le capacity le 200 then; airplanetype = 'Small'; staff = 5; else; airplanetype = 'Large'; staff = 10; run;

  Correct Answer: B

• Question 110:

  The following SAS program is submitted:

  data work.staff;

  JobCategory = 'FA';

  JobLevel = '1';

  JobCategory = JobCategory || JobLevel;

  run;

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

  A. FA

  B. FA1

  C. FA 1

  D. ' ' (missing character value)

  Correct Answer: A