SASInstitute SAS Institute Systems Certification A00-211 Questions & Answers

• Question 11:

  Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

  

  The following SAS program is submitted:

  proc sort data=WORK.TEMPS; by Day descending Month; run;

  proc print data=WORK.TEMPS; run;

  Which output is correct?

  

  A. B. C. D.

  Correct Answer: B

• Question 12:

  This questions will ask you to provide two missing variable names.

  The following SAS program is submitted:

  data WORK.TOTAL;

  set WORK.SALARY;

  by Department Gender;

  if First. then Payroll=0

  Payroll+Wagerate; if Last.; run;

  The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

  variable 2: Department

  A. variable 1: Gender

  B. variable 1: Gender variable 2: Gender

  C. variable 1: Department variable 2: Gender variable 2: Department

  D. variable 1: Department

  Correct Answer: B

• Question 13:

  Given the SAS data set WORK.THREE:

  

  The following SAS program is submitted:

  

  What is the result?

  

  A. B. C. D.

  Correct Answer: A

• Question 14:

  The following SAS program is submitted:

  

  What is the value of the variable var1?

  A. `1/15/1960'

  B. 15

  C. 1151960

  D. 14

  Correct Answer: D

• Question 15:

  This question will ask you to provide a line of missing code.

  The following SAS program is submitted:

  proc freq data = WORK.SALES;

  run;

  The following output is created by the FREQUENCY procedure:

  

  Which statement was used to complete the above program that produced the output?

  A. tables region product;

  B. var region * product;

  C. tables region*product;

  D. var region product;

  Correct Answer: C

• Question 16:

  Given the following SAS data set WORK.EMPDATA:

  

  Which WERE statement would display observations wit Job_Title containing the word "Manager"? `))='MANAGER';

  A. where upcase(scan(Job_Title,-1,'

  B. where Job_Title like `Manager%';

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

  D. where Job_Title='% Manager `;

  Correct Answer: D

• Question 17:

  By default, which variables and data values are used to calculate statistics in the MEANS procedure?

  A. all non-missing numeric variable values

  B. all missing and non-missing numeric variable values and numbers stored as character variables.

  C. all non-missing numeric variable values and numbers stored as character variables

  D. all missing and non-missing numeric variable values

  Correct Answer: A

• Question 18:

  A user-defined format has been created using the FORMAT procedure. How is it stored?

  A. in a SAS catalog

  B. in a memory resident lookup table

  C. in a SAS data set in the WORK library

  D. in a SAS dataset in a permanent SAS data library

  Correct Answer: A

• Question 19:

  This question will ask you to provide lines of missing code.

  The following SAS program is submitted:

  

  Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?

  

  A. B. C. D.

  Correct Answer: A

• Question 20:

  This question will ask you to provide a missing option. Given the following SAS program:

  

  Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

  A. label = `*'

  B. labelsplit = `*'

  C. split = `*'

  D. wrap = `*'

  Correct Answer: B

  Reference: http://documentation.sas.com/? docsetId=grstatgraphanddocsetTarget=p1annoywcvho57n1icmu2fjmyerb.htmanddocsetVersion=9.4andlocale=en