Chapter Quiz

Select the best answer for each question. Check your answers using the answer key in the appendix.
  1. Which program combines Brothers.One and Brothers.Two to produce Brothers.Three?
    Which program combines Brothers.One and Brothers.Two to produce Brothers.Three?
    1. data work.three;
   set work.one; 
   set work.two; 
run;
proc print data=work.three;
run;
    2. data work.three; 
   set work.one work.two; 
run;
proc print data=work.three;
run;
    3. data work.three;
   set work.one work.two; 
   by varx; 
run;
proc print data=work.three;
run;
    4. data work.three;
   merge work.one work.two; 
   by varx; 
run;
proc print data=work.three;
run;
  2. Which program combines Actors.Props1 and Actors.Props2 to produce Actors.Props3?
    Which program combines Actors.Props1 and Actors.Props2 to produce Actors.Props3?
    1. data actors.props3;
   set actors.props1; 
   set actors.props2; 
run;
    2. data actors.props3;
   set actors.props1 actors.props2; 
run;
    3. data actors.props3;
   set actors.props1 actors.props2; 
   by actor; 
run;
    4. data actors.props3;
   merge actors.props1 actors.props2; 
   by actor; 
run;
  3. If you submit the following program, which new data set is created?
    If you submit the following program, which new data set is created?
    data work.jobsatis; 
   set work.dataone work.datatwo; 
run;
proc print data=work.jobsatis noobs;
run;
    1. data set
    2. data set
    3. data set
    4. none of the above
  4. If you concatenate the data sets below in the order shown, what is the value of Sale in observation 2 of the new data set?
    If you concatenate the data sets below in the order shown, what is the value of Sale in observation 2 of the new data set?
    1. missing
    2. $30,000
    3. $40,000
    4. You cannot concatenate these data sets.
  5. What happens if you merge the following data sets by the variable SSN?
    What happens if you merge the following data sets by the variable SSN?
    1. The values of Age in the data set 1st overwrite the values of Age in the data set 2nd.
    2. The values of Age in the data set 2nd overwrite the values of Age in the data set 1st.
    3. The DATA step fails because the two data sets contain same-named variables that have different values.
    4. The values of Age in the data set 2nd are set to missing.
  6. Suppose you merge data sets Health.Set1 and Health.Set2 below:
    Suppose you merge data sets Health.Set1 and Health.Set2 below:
    Which output does the following program create? 
    data work.merged; 
   merge health.set1(in=in1) health.set2(in=in2); 
   by id; 
   if in1 and in2; 
run; 
proc print data=work.merged; 
run;
    1. output
    2. output
    3. output
    4. none of the above
  7. The data sets Ensemble.Spring and Ensemble.Sum both contain a variable named Blue. How do you prevent the values of the variable Blue from being overwritten when you merge the two data sets? 
    1. data ensemble.merged; 
   merge ensemble.spring(in=blue) 
         ensemble.summer; 
   by fabric; 
run;
    2. data ensemble.merged; 
   merge ensemble.spring(out=blue) 
         ensemble.summer; 
   by fabric; 
run; 
    3. data ensemble.merged; 
   merge ensemble.spring(blue=navy) 
         ensemble.summer; 
   by fabric; 
run;
    4. data ensemble.merged; 
   merge ensemble.spring(rename=(blue=navy)) 
         ensemble.summer; 
   by fabric; 
run;
  8. What happens if you submit the following program to merge Blood.Donors1 and Blood.Donors2, shown below? 
    data work.merged;
   merge blood.donors1 blood.donors2; 
   by id; 
run
    output
    1. The merged data set contains some missing values because not all observations have matching observations in the other data set.
    2. The merged data set contains eight observations.
    3. The DATA step produces errors.
    4. Values for Units in Blood.Donors2 overwrite values of Units in Blood.Donors1.
  9. If you merge Company.Staff1 and Company.Staff2 below by ID, how many observations does the new data set contain?
    output
    1. 4
    2. 5
    3. 6
    4. 9
  10. If you merge data sets Sales.Reps, Sales.Close, and Sales.Bonus by ID, what is the value of Bonus in the third observation in the new data set?
    If you merge data sets Sales.Reps, Sales.Close, and Sales.Bonus by ID, what is the value of Bonus in the third observation in the new data set?
    1. $4,000
    2. $3,000
    3. missing
    4. You cannot tell from the information given.
Last updated: January 10, 2018
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.235.62