A00-211

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

Question 11

The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Why does the program rail to execute?

  1. The SORT procedures contain invalid syntax.
  2. The merged data sets are not permanent SAS data sets.
  3. The RUN statement was omitted alter each or the SORT procedures.
  4. The data sets were not merged in the order by which they were sorted.

Question 12

The following SAS program is submittad: data work.sales; do year = 1 to 5; do month=1 to 12; x+1; output end; end; run; How many observations are written the WORK SALES data set?

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

Question 13

Given the following raw data record: ----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname - 1 son Travis Which SAS program correctly reads in the raw data?

  1. data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;
  2. options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;
  3. data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;
  4. data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;

Question 14

Given the SAS data set AGES: AGES - AGE - --------- The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run; How many observations are written out to the data set SUBSET?

  1. 0
  2. 1
  3. 2
  4. 3

Question 15

Given the SAS data set PRICES: PRICES - prodid price K12S 5.10 producttype - NETWORK sales - 15 returns B132S 2.34 HARDWARE 300 10 R18KY21.29 SOFTWARE 25 5 3KL8BY 6.37 HARDWARE 125 15 DY65DW 5.60 HARDWARE 45 5 DGTY23 4.55 HARDWARE 67 2 The following SAS program is submitted: data hware inter soft; set prices (keep = producttype price); if price le 5.00; if producttype = HARDWARE then output HWARE; else if producttype = NETWORK then output INTER; else if producttype = SOFTWARE then output SOFT; run; How many observations does the HWARE data set contain?

  1. 0
  2. 2
  3. 3
  4. 4