SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 21:

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

  

  A. 1
  C. -99
  D. -1
  C. -99

• Question 22:

  The following SAS program is submitted: proc contents data = sashelp.class varnum; quit;

  What does the VARNUM option print?

  A. a list of variable names
  B. the total number of variables
  C. a list of the variables in alphabetic order
  D. a list of the variables in the order they were created
  D. a list of the variables in the order they were created

• Question 23:

  Which one of the following is true of the RETAIN statement in a SAS DATA step program?

  A. It can be used to assign an initial value to _N_ .
  B. It is only valid in conjunction with a SUM function.
  C. It has no effect on variables read with the SET, MERGE and UPDATE statements.
  D. It adds the value of an expression to an accumulator variable and ignores missing values.
  C. It has no effect on variables read with the SET, MERGE and UPDATE statements.

• Question 24:

  The following SAS program is submitted:

  options pageno = 1;

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  The report created by the PRINT procedure step generates 5 pages of output.

  What is the page number on the first page of the report generated by the MEANS procedure step?

  A. 1
  B. 2
  C. 5
  D. 6
  D. 6

• Question 25:

  Given the following raw data records:

  

  The following output is desired:

  

  Which SAS program correctly reads in the raw data?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 26:

  The following SAS program is submitted:

  data work.sets;

  do until (prod gt 6);

  prod + 1;

  end;

  run;

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

  A. 6
  B. 7
  C. 8
  D. (missing numeric)
  B. 7

• Question 27:

  The following SAS program is submitted:

  

  What value will SAS assign to Pos?

  A. 12
  A. 12

• Question 28:

  What describes the SAS automatic _ERROR_ variable?

  A. The _ERROR_ variable contains the values `TRUE' or `FALSE.'
  B. The _ERROR variable maintains a count of the number of data errors.
  C. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
  D. The ERROR_variable contains the number or the observation that caused the error.
  C. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

• Question 29:

  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_";
  C. libname sasdata "_SAS_data_library_location_";

• Question 30:

  The following SAS program is submitted:

  proc freq data = class;

  tables gender * age / ;

  run;

  The following report is created:

  The FREQ Procedure

  Table of gender by age

  Row Column

  Gender age Frequency Percent Percent Percent

  F 11 1 10.00 20.00 50.00

  12 2 20.00 40.00 40.00

  13 2 20.00 40.00 66.67

  Total 5 50.00 100.00

  M 11 1 10.00 20.00 50.00

  12 3 30.00 60.00 60,00

  13 1 10.00 20.00 33.33

  Total 5 50.00 100.00

  Total 11 2 20.00 100.00

  12 5 50.00 100.00

  13 3 30.00 100.00

  Total 10 100.00

  Which option correctly completes the program and creates the report?

  A. LIST
  B. NOCOLS
  C. CROSSLIST
  D. NOCROSSTAB
  C. CROSSLIST