1512743
Beschreibung
Quiz von James Blair, aktualisiert more than 1 year ago
|
Erstellt von James Blair
vor mehr als 9 Jahre
|
|
Frage 1
Frage
Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?
Image:
Q12_1 (image/jpg)
Antworten
-
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;
Frage 2
Frage
Which program will combine Actors.Props1 and Actors.Props2 to produce Actors.Props3?
Image:
Q12_2 (image/jpg)
Antworten
-
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;
Frage 3
Antworten
-
a.Image:Q12_3a (image/jpeg)
-
b.Image:Q12_3b (image/jpeg)
-
c.Image:Q12_3c (image/jpeg)
-
d. None of the above
Frage 4
Frage
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)
Antworten
-
a. missing
-
b. $ 30,000
-
c. $ 40,000
-
d. you cannot concatenate these data sets
Frage 5
Frage
What happens if you merge the following data sets by the variable SSN?
Image:
Q12_5 (image/jpg)
Antworten
-
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.
Frage 6
Frage
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)
Antworten
-
a.Image:Q12_6a (image/jpeg)
-
b.Image:Q12_6b (image/jpeg)
-
c.Image:Q12_6c (image/jpeg)
-
d. None of the above
Frage 7
Frage
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?
Antworten
-
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;
Frage 8
Frage
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)
Antworten
-
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.
Frage 9
Frage
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)
Antworten
-
a. 4
-
b. 5
-
c. 6
-
d. 9
Frage 10
Frage
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)
Antworten
-
a. $4,000
-
b. $3,000
-
c. missing
-
d. can't tell from the information given
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.