SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 191:

  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.

  Correct Answer: C

• Question 192:

  The Excel workbook REGIONS.XLS contains the following four worksheets:

  EAST WEST NORTH SOUTH

  The following program is submitted: libname MYXLS 'regions.xls';

  Which PROC PRINT step correctly displays the NORTH worksheet?

  A. proc print data=MYXLS.NORTH; run;

  B. proc print data=MYXLS.NORTH$; run;

  C. proc print data=MYXLS.'NORTH'e; run;

  D. proc print data=MYXLS.'NORTH$'n; run;

  Correct Answer: D

• Question 193:

  Given the data set WORK.EMPDATA:

  

  Which one of the following where statements would display observations with job titles containing the word 'Manager'?

  A. where substr(Job_Title,(length(Job_Title)-6))='Manager';

  B. where upcase(scan(Job_Title,-1,' '))='MANAGER';

  C. where Job_Title='% Manager ';

  D. where Job_Title like '%Manager%';

  Correct Answer: D

• Question 194:

  The following SAS program is submitted:

  data WORK.DATE_INFO; X="01Jan1960" D;

  run;

  What variable X contains what value?

  A. the numeric value 0

  B. the character value "01Jan1960"

  C. the date value 01011960

  D. the code contains a syntax error and does not execute.

  Correct Answer: A

• Question 195:

  Given the SAS data set WORK.EMP_NAME:

  

  Given the SAS data set WORK.EMP_DEPT:

  

  The following program is submitted:

  

  How many observations are in data set WORK.ALL after submitting the program?

  A. 1

  B. 2

  C. 3

  D. 5

  Correct Answer: B

• Question 196:

  The following SAS program is submitted:

  proc means data = sasuser.shoes;

  where product in (`Sandal' , `Slipper' , `Boot');

  run;

  Which ODS statements complete the program and send the report to an HTML file?

  A. ods html = `sales.html'; ods html close;

  B. ods file = `sales.html'; ods file close;

  C. ods file html = `sales.html'; ods file close;

  D. ods html file = `sales.html'; ods html close;

  Correct Answer: D

• Question 197:

  Given the raw data file AMOUNT:

  ----I---- 10---I----20---I----30

  $1,234

  The following SAS program is submitted:

  data test;

  infile `amount';

  input@1 salary 6.;

  if_error_then description = `Problems';

  else description = `No Problems';

  run;

  What is the result?

  A. The value of the DESCRIPTION variable is No Probl.

  B. The value of the DESCRIPTION variable is Problems.

  C. The value of the DESCRIPTION variable is No Problems.

  D. The value of the DESCRIPTION variable can not be determined.

  Correct Answer: B

• Question 198:

  Given the SAS data set PEPM.STUDENTS:

  PERM.STUDENTS NAME AGE

  --------- ------ Alfred 14

  Alice13

  Barbara13

  Carol14

  The following SAS program is submitted:

  libname perm `SAS data library';

  data students;

  set perm.students;

  file `file specification';

  put name $15. @5 age 2.;

  run;

  What is written to the output raw data file?

  A. ----I----10---I----20---I----30 Alfred 14 Alice 13

  Barbara 13

  Carol 14

  B. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4

  C. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141

  D. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14

  Correct Answer: B

• Question 199:

  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 WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for

  each of 5 departments.

  What is the result?

  A. The WORK.TOTAL data set contains 5 observations.

  B. The WORKTDTAL data set contains 100 observations.

  C. The WORKTOTAL data set contains 500 observations.

  D. The program fails to execute due to errors.

  Correct Answer: A

• Question 200:

  The following SAS program is submitted;

  data combine;

  country = `Italy, Russia, ireland';

  found = find(country, `i');

  run;

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

  A. 1

  B. 12

  C. Italy D. Russia

  Correct Answer: B