SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 41:

  Given the contents of the raw data file 'EMPLOYEE.TXT'

  

  Which SAS informat correctly completes the program?

  A. date9
  B. mmddyy10
  C. ddmmyy10
  D. mondayyr10
  B. mmddyy10

• Question 42:

  The following SAS program is submitted:

  

  If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

  A. Grad Level
  B. Unknown
  C. GRAD LEVEL
  D. `' (missing character value)
  A. Grad Level

• Question 43:

  The following SAS program is submitted:

  proc means data = sasuser.shoes;

  where product in (`Sandal' , `Slipper' , `Boot');

  run;

  Which ODS statements complete the program and send the report to an HTML file?

  A. ods html = `sales.html'; ods html close;
  B. ods file = `sales.html'; ods file close;
  C. ods file html = `sales.html'; ods file close;
  D. ods html file = `sales.html'; ods html close;
  D. ods html file = `sales.html'; ods html close;

• Question 44:

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

  

  The following SAS program is submitted:

  

  In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.

  A. Check the answer below.
  A. Check the answer below.

• Question 45:

  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
  A. all non-missing numeric variable values

• Question 46:

  Given the raw data file EMPLOYEE.TXT:

  

  The following SAS program is submitted:

  

  What value does the variable idnum contain when the name of the employee is "Ruth"?

  A. 33
  B. 22
  C. 39
  D. 44
  B. 22

• Question 47:

  You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

  

  What does it mean?

  A. A compiler error, triggered by an invalid character for the variable Salary.
  B. An execution error, triggered by an invalid character for the variable Salary.
  C. The 1st of potentially many errors, this one occurring on the 4th observation.
  D. An error on the INPUT statement specification for reading the variable Salary.
  B. An execution error, triggered by an invalid character for the variable Salary.

• Question 48:

  A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:

  Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1 The following SAS program is submitted: data work.expertise; set work.levels; if level = . then expertise = 'Unknown'; else if level = 1 then expertise = 'Low'; else if level = 2 or 3 then expertise = 'Medium'; else expertise = 'High'; run;

  Which of the following values does the variable EXPERTISE contain?

  A. Low, Medium, and High only
  B. Low, Medium, and Unknown only
  C. Low, Medium, High, and Unknown only
  D. Low, Medium, High, Unknown, and ' ' (missing character value)
  B. Low, Medium, and Unknown only

• Question 49:

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

  A. It is only valid in conjunction with a SUM function.
  B. It is not valid with the SET, MERGE and UPDATE statements.
  C. It adds the value of an expression to an accumulator variable and ignores missing values.
  D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
  C. It adds the value of an expression to an accumulator variable and ignores missing values.

• Question 50:

  Given the SAS data set ONE:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  Which report is produced?

  

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