Zusammenfassung der Ressource
Frage 1
Frage
Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?
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?
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
Frage
If you submit the following program, which new data set is created?
Antworten
-
a.
-
b.
-
c.
-
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?
Frage 5
Frage
What happens if you merge the following data sets by the variable SSN?
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;
Antworten
-
a.
-
b.
-
c.
-
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
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?
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?