SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 31:

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

  A. infile 'customer.txt' eof=10;

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

  C. infile 'customer.txt' obs=10; D. infile 'customer.txt' obs=1-10;

  Correct Answer: D

• Question 32:

  Given the following raw data records:

  

  The following output data set is desired:

  

  Which SAS program correctly reads in the raw data?

  

  A. B. C. D.

  Correct Answer: C

• Question 33:

  The Excel workbook REGIONS.XLSX contains the following four worksheets: EAST

  WEST NORTH SOUTH

  The following program is submitted: libname MYXLS pcfiles path='c:\regions.xlsx';

  Which PROC PRINT step correctly displays the NORTH worksheet?

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

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

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

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

  Correct Answer: B

• Question 34:

  

  The following SAS program is submitted:

  

  What is the value of the price variable?

  A. No value is stored.

  B. $25.31

  C. . (missing numeric value)

  D. 25.31

  Correct Answer: C

• Question 35:

  The following SAS program is submitted: What is the value of the variable Diff?

  

  A. 1

  B. 0

  C. -99

  D. -1

  Correct Answer: C

• Question 36:

  How many of the following SAS data set names are valid?

  

  A. 4

  B. 3

  C. 1

  D. 2

  Correct Answer: D

  Reference: http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/ viewer.htm#p18cdcs4v5wd2dn1q0x296d3qek6.htm

• Question 37:

  Which program will create a comma delimited raw data file (CSV)?

  

  A.

  

  B. C. D.

  Correct Answer: B

• Question 38:

  This question will ask you to provide a line of missing code. Given the following data set WORK.SALES:

  

  The following program is submitted:

  

  Which statement should be inserted to produce the following output?

  

  A. Qtr1 = sum(of month {*});

  B. Qtr1 = sum(of month {3});

  C. Qtr1 = month{1} + month{2} + month {3};

  D. Qtr1 = sum(of month{_ALL_});

  Correct Answer: A

  Reference: http://biexamacademy.com/sas-base-certification-question-8/

• Question 39:

  The following SAS program is submitted: How many observations are written to the WORK.VOLUME data set?

  

  A. 1

  Correct Answer: A

  Reference: http://sascert.blogspot.com/2006/12/base-sas_116664843451215561.html

• Question 40:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  What value will SAS assign to Total?

  A. 4.8

  B. 1.6

  C. (missing value)

  D. 1.2

  Correct Answer: B