# Chapter 12: Combining SAS Data Sets

Quiz by James Blair, updated more than 1 year ago
 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?
• 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?
• 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?

### 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?
• 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?
• 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;

### 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?
• 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
• 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?
• 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?
• a. \$4,000
• b. \$3,000
• c. missing
• d. can't tell from the information given

### Similar

Statistics Key Words
SAMPLING
CUMULATIVE FREQUENCY DIAGRAMS
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
HISTOGRAMS
TYPES OF DATA
GROUPED DATA FREQUENCY TABLES: MODAL CLASS AND ESTIMATE OF MEAN
Statistics Vocab
HTTPS explained with Carrier Pigeons
chapter 1,2 statistics
Statistics, Data and Area (Semester 2 Exam)