1512743
Description
Quiz by James Blair, updated more than 1 year ago
|
Created by James Blair
about 10 years ago
|
|
Question 1
Question
Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?
Image:
Q12_1 (image/jpg)
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?
Image:
Q12_2 (image/jpg)
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?
Image:
Q12_3 (image/jpg)
Answer
-
a.Image:Q12_3a (image/jpeg)
-
b.Image:Q12_3b (image/jpeg)
-
c.Image:Q12_3c (image/jpeg)
-
d. None of the above
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?
Image:
Q12_4 (image/jpg)
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?
Image:
Q12_5 (image/jpg)
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;
Image:
Q12_6 (image/jpg)
Answer
-
a.Image:Q12_6a (image/jpeg)
-
b.Image:Q12_6b (image/jpeg)
-
c.Image:Q12_6c (image/jpeg)
-
d. None of the above
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
Image:
Q12_8 (image/jpg)
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?
Image:
Q12_9 (image/jpg)
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?
Image:
Q12_10 (image/jpg)
Answer
-
a. $4,000
-
b. $3,000
-
c. missing
-
d. can't tell from the information given
Want to create your own Quizzes for free with GoConqr? Learn more.