SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 171:

  The following output is created by the FREQUENCY procedure:

  

  Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

  A. norowcount nocolcount

  B. freq percent

  C. norow nocol D. nocounts

  Correct Answer: C

• Question 172:

  The Excel workbook QTR1.XLS contains the following three worksheets:

  JAN FEB MAR

  Which statement correctly assigns a library reference to the Excel workbook?

  A. libname qtrdata 'qtr1.xls';

  B. libname 'qtr1.xls' sheets=3;

  C. libname jan feb mar 'qtr1.xls';

  D. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);

  Correct Answer: A

• Question 173:

  Which is a valid LIBNAME statement?

  A. libname "_SAS_data_library_location_";

  B. sasdata libname "_SAS_data_library_location_";

  C. libname sasdata "_SAS_data_library_location_";

  D. libname sasdata sas "_SAS_data_library_location_";

  Correct Answer: C

• Question 174:

  Which statement is true concerning the SAS automatic variable _ERROR_?

  A. It cannot be used in an if/then condition.

  B. It cannot be used in an assignment statement.

  C. It can be put into a keep statement or keep= option.

  D. It is automatically dropped.

  Correct Answer: D

• Question 175:

  Given the SAS data set WORK.TEMPS:

  

  The following program is submitted:

  

  Which output is correct?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 176:

  The following SAS program is submitted:

  data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode='Job Description'; run;

  Which statement is true about the output dataset?

  A. The label of the variable Jobcode is Job (only the first word).

  B. The label of the variable Jobcode is Job Desc (only the first 8 characters).

  C. The label of the variable Jobcode is Job Description.

  D. The program fails to execute due to errors. Labels must be defined in a PROC step.

  Correct Answer: C

• Question 177:

  The following SAS program is submitted:

  

  What types of variables are DayOfMonth, MonthOfYear, and Year?

  A. DayOfMonth, Year, and MonthOfYear are character.

  B. DayOfMonth, Year, and MonthOfYear are numeric.

  C. DayOfMonth and Year are numeric. MonthOfYear is character.

  D. DayOfMonth, Year, and MonthOfYear are date values.

  Correct Answer: B

• Question 178:

  The following SAS program is submitted:

  data ONE TWO SASUSER.TWO

  set SASUSER.ONE;

  run;

  Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

  A. 2 temporary and 1 permanent SAS data sets are created

  B. 3 temporary and 2 permanent SAS data sets are created

  C. 2 temporary and 2 permanent SAS data sets are created

  D. there is an error and no new data sets are created

  Correct Answer: D

• Question 179:

  The following code was modified to generate the results further below:

  proc format; value agegrp low-12 ='Pre-Teen'

  13-high = 'Teen';

  run;

  proc means data=SASHELP.CLASS;

  var Height;

  class Sex Age;

  format Age agegrp.;

  run;

  The following results were generated to display only specific statistics and limit the decimals with the

  modification: Which statement below was modified or added to generate the results above:

  

  A. var Height / nobs min max mean maxdec=1;

  B. proc means data=SASHELP.CLASS maxdec=1 ;

  C. proc means data=SASHELP.CLASS min max mean maxdec=1;

  D. output nobs min max mean maxdec=1;

  Correct Answer: C

• Question 180:

  The following SAS program is submitted:

  

  How will the Exam variable value be displayed in the FREQ procedure output?

  A. Fail

  B. Pass

  C. 50.5

  D. . (missing numeric value)

  Correct Answer: C