A00-211

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

Question 21

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

  1. 0
  2. 1
  3. 5
  4. 60

Question 22

The following SAS program is submitted: The program fails execution due to syntax errors. What is the cause of the syntax error?

  1. The variable MONTHSALES does not exist.
  2. An array cannot be referenced on a KEEP data set option.
  3. The KEEP= data set option should be (KEEP = MONTHSALES).
  4. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.

Question 23

Given the SAS data set EMPLOYEES: EMPLOYEES - NAME SALARY - -------- ------------ Innis 60000 - Jolli 50000 - Ellis 55000 - Liu 45000 - The following SAS program is submitted: proc print data = employees; where name like _i%; run; What is contained in the output?

  1. Liu only
  2. Innis and Ellis only
  3. Innis, Ellis, and Liu only
  4. Innis, Jolli, Ellis, and Liu

Question 24

Given the SAS data set ONE: ONE - Obs Dte - ----- -------- 1 09JAN2005 2 12JAN2005 The following SAS program is submitted: data two; set one; day = ; format dte date9.; run; The data set TWO is created: TWO - Obs Dte Day - 1 09JAN2005 1 12 JAN2005 4 Which expression successfully completed the program and created the variable DAY?

  1. day(dte)
  2. weekday(dte)
  3. dayofweek(dte)
  4. datdif(dte,’01jan2005’d,’act/act’)

Question 25

Read the table: Given the SAS data set SASUSER.HOUSES: Obs style bedrooms baths price sqteet street 1 CONDO 2 1.5 80050 1200 MAIN 2 CONDO 3 2.5 79350 1300 ELM 3 CONDO 4 2.5 127150 1400 OAK 4 CONDO 2 2.0 110700 1100 FIFTH 5 TWOSTORY 4 3.0 107250 2100 SECOND 6 TWOSTORY 2 1.0 55650 1600 WEST 7 TWOSTORY 2 1.0 69250 1450 NORTH 6 TWOSTORY 4 2.5 102950 2000 SOUTH The following SAS program is submitted: proc report data = sasuser.houses nowd headline; column style price; where price It 100000; define price / mean width = 9 format = dollar12.; title; run; The following output is desired: style price ------- ------ CONDO $79,700 - TWOSTORY $62550 - Which DEFINE statement completes the program and produces the desired output?

  1. define style / width = 9,
  2. define style / orderwidth = 9;
  3. define style / group width = 9;
  4. define style / display width = 9;