Chapter 12: Combining SAS Data Sets

James Blair
Quiz by James Blair, updated more than 1 year ago
James Blair
Created by James Blair about 7 years ago
90
1

Description

Quiz on Chapter 12: Combining SAS Data Sets, created by James Blair on 10/22/2014.

Resource summary

Question 1

Question
Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?
Answer
  • a. data brothers.three; set brothers.one; set brothers.two; run;
  • b. data brothers.three; set brothers.one brothers.two; run;
  • c. data brothers.three; set brothers.one brothers.two; by varx; run;
  • d. data brothers.three; merge brothers.one brothers.two; by varx; run;

Question 2

Question
Which program will combine Actors.Props1 and Actors.Props2 to produce Actors.Props3?
Answer
  • a. data actors.props3; set actors.props1; set actors.props2; run;
  • b. data actors.props3; set actors.props1 actors.props2; run;
  • c. data actors.props3; set actors.props1 actors.props2; by actor; run;
  • d. data actors.props3; merge actors.props1 actors.props2; by actor; run;

Question 3

Question
If you submit the following program, which new data set is created?
Answer

Question 4

Question
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?
Answer
  • a. missing
  • b. $ 30,000
  • c. $ 40,000
  • d. you cannot concatenate these data sets

Question 5

Question
What happens if you merge the following data sets by the variable SSN?
Answer
  • a. The values of Age in the 1st data set overwrite the values of Age in the 2nd data set.
  • b. The values of Age in the 2nd data set overwrite the values of Age in the 1st data set.
  • c. The DATA step fails because the two data sets contain same-named variables that have different values.
  • d. The values of Age in the 2nd data set are set to missing.

Question 6

Question
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;
Answer

Question 7

Question
The data sets Ensemble.Spring and Ensemble.Summer 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?
Answer
  • a. data ensemble.merged; merge ensemble.spring( in = blue) ensemble.summer; by fabric; run;
  • b. data ensemble.merged; merge ensemble.spring( out = blue) ensemble.summer; by fabric; run;
  • c. data ensemble.merged; merge ensemble.spring( blue = navy) ensemble.summer; by fabric; run;
  • d. data ensemble.merged; merge ensemble.spring( rename =( blue = navy)) ensemble.summer; by fabric; run;

Question 8

Question
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
Answer
  • a. The Merged data set contains some missing values because not all observations have matching observations in the other data set.
  • b. The Merged data set contains eight observations.
  • c. The DATA step produces errors.
  • d. Values for Units in Blood.Donors2 overwrite values of Units in Blood.Donors1.

Question 9

Question
If you merge Company.Staff1 and Company.Staff2 below by ID, how many observations does the new data set contain?
Answer
  • a. 4
  • b. 5
  • c. 6
  • d. 9

Question 10

Question
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?
Answer
  • a. $4,000
  • b. $3,000
  • c. missing
  • d. can't tell from the information given
Show full summary Hide full summary

Similar

Statistics Key Words
Culan O'Meara
SAMPLING
Elliot O'Leary
CUMULATIVE FREQUENCY DIAGRAMS
Elliot O'Leary
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
Elliot O'Leary
HISTOGRAMS
Elliot O'Leary
TYPES OF DATA
Elliot O'Leary
GROUPED DATA FREQUENCY TABLES: MODAL CLASS AND ESTIMATE OF MEAN
Elliot O'Leary
Statistics Vocab
Nabeeha Yusuf
HTTPS explained with Carrier Pigeons
Shannon Anderson-Rush
chapter 1,2 statistics
Rigo Sanchez
Statistics, Data and Area (Semester 2 Exam)
meg willmington