A00-211

A00-211 practice questions, page 9 of 11, with answer review and explanations.

Question 41

The following SAS program is submitted: data work.test; set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3; array monthly{3} jansales febsales marsales; run; What new variables are created?

  1. JANSALES, FEBSALES and MARSALES
  2. MONTHLY1, MONTHLY2 and MONTHLY3
  3. DIFSALES1, DIFSALES2 and DIFSALES3
  4. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

Question 42

What describes the SAS automatic _ERROR_ variable?

  1. The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’
  2. The _ERROR variable maintains a count of the number of data errors.
  3. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
  4. The ERROR_variable contains the number or the observation that caused the error.

Question 43

Given the following raw data record: 07Jan2005 Which INFORMAT reads this raw data and stores it as a SAS date value?

  1. dmy9.
  2. date9.
  3. ddMMMyy9.
  4. ddmmmyyyy9.

Question 44

Which statement correctly computes the average of four numerical values?

  1. average = mean(num1, num4);
  2. average = mean(num1 - num4);
  3. average = mean(ofnum1 - num4)
  4. average = mean(num1 num2 num3 num4);

Question 45

The following SAS program is submitted: libname temp SAS data library; data temp.sales; merge temp.sales work.receipt; by names; run; The input data files are sorted by the NAMES variable: What is the result?

  1. The program executes successfully and a temporary SAS data set is created.
  2. The program executes successfully and a permanent SAS data set is created.
  3. The program fails execution because the same SAS data set is referenced for both read and write operations.
  4. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.