Chapter 12: Combining SAS Data Sets

1

Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?

1

Which program will combine Actors.Props1 and Actors.Props2 to produce Actors.Props3?

1

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

1

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?

1

What happens if you merge the following data sets by the variable SSN?

1

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;

1

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?

1

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

1

If you merge Company.Staff1 and Company.Staff2 below by ID, how many observations does the new data set contain?

1

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?

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

Chapter 12: Combining SAS Data Sets

Which program will combine Brothers.One and Brothers.Two to produce Brothers.Three?

Which program will combine Actors.Props1 and Actors.Props2 to produce Actors.Props3?

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

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?

What happens if you merge the following data sets by the variable SSN?

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;

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?

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

If you merge Company.Staff1 and Company.Staff2 below by ID, how many observations does the new data set contain?

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?

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;

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