SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 181:

  The following program is submitted:

  proc sort data=SASUSER.PROJECTS out=PSORT;

  by Code descending Date Cost;

  run;

  Which of the following is true concerning the submitted program?

  A. The descending option applies to the variable Code.

  B. The variable Code is sorted by ascending order.

  C. The PSORT data set is stored in the SASUSER library.

  D. The descending option applies to the Date and Cost variables.

  Correct Answer: B

• Question 182:

  The following program is submitted:

  proc contents data=_all_;

  run;

  Which statement best describes the output from the submitted program?

  A. The output contains only a list of the SAS data sets that are contained in the WORK library.

  B. The output displays only the contents of the SAS data sets that are contained in the WORK library.

  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.

  D. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

  Correct Answer: D

• Question 183:

  Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

  A. infile 'customer.txt' 1-10;

  B. input 'customer.txt' stop@10;

  C. infile 'customer.txt' obs=10;

  D. input 'customer.txt' stop=10;

  Correct Answer: C

• Question 184:

  The following SAS program is submitted:

  data WORK.ONE;

  Text='Australia, US, Denmark';

  Pos=find(Text,'US','i',5);

  run;

  What value will SAS assign to Pos?

  A. 0

  B. 1

  C. 2

  D. 12

  Correct Answer: D

• Question 185:

  Given the following raw data records in DATAFILE.TXT:

  

  Which output is correct based on the submitted program?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 186:

  The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:

  WORK.ONE Num Char

  1 23 3 23 1 77 The following SAS program is submitted: proc print data=WORK.ONE;

  where Num='1'; run;

  What is output?

  A. Num Char 1 23

  B. Num Char

  1 23

  1 77

  C. Num Char

  1 23

  3 23

  1 77

  D. No output is generated.

  Correct Answer: D

• Question 187:

  The following output is created by the FREQUENCY procedure:

  

  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;

  Correct Answer: D

• Question 188:

  The following SAS program is submitted:

  <_insert_ods_code_>

  proc means data=SASUSER.SHOES;

  where Product in ('Sandal' , 'Slipper' , 'Boot');

  run;

  <_insert_ods_code_>

  Which ODS statements inserted, respectively, in the two location above creates a report stored in an html

  file?

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

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

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

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

  Correct Answer: C

• Question 189:

  Given the following data step:

  

  After data step execution, what will data set WORK.GEO contain?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 190:

  Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

  A. MSOFFICE2K

  B. EXCELXP

  C. CSVALL

  D. WINXP

  Correct Answer: D