Chapter Review Quiz SAS logo

Combining SAS Data Sets

Select the best answer for each question. When you are finished, click Submit Quiz.

Which statement is true concerning match-merging?

a. The MERGE statement must refer to permanent data sets.

b. The variables in the BY statement can be in only one of the data sets.

c. Only two data sets can be specified in the MERGE statement.

d. When using the MERGE statement with the BY statement, the data must be sorted or indexed on the BY variables.

Which of the following data set options can be added to the MERGE statement to help identify data set contributors (that is, identify the matches)?

a.  OBS=

b.  IN=

c.  RENAME=

d.  MATCHES=

If you execute the following DATA step, which observations does the data set bonuses contain?

data bonuses;
   merge managers(in=M) 
         staff(in=S);
   by EmpID;
   if M=0 and S=1;
run;;

a. the observations from staff that have no match in managers

b. the observations from managers that have no match in staff

c. all observations from both managers and staff

d. none of the above

Which subsetting IF statement selects observations for subsequent processing only if all three input data sets contribute to the current observation?

data merged.flowers;
   merge spring.roses(rename=(red=BrickRed) in=yellow)
         spring.lilacs(in=purple)
         spring.petunias(in=pink);
   by ID;
   _________________________
run;

a. if yellow=1 and purple=1 or pink=1;

b. if yellow=0 or purple=0 or pink=0;

c. if yellow=1 and purple=1 and pink=1;

d. if yellow=1 or purple=1 and pink=0;

The following program will execute without errors:

data work.merged;
   merge blood.donors1 blood.donors2;
   by ID;
run;

blood.donors1

Type

Units

2304

1129

2486

blood.donors2

Code

Units

6488

1129

5438

2304

1387

a. True

b. False

Can these three data sets be merged in one DATA step?

Hair

Makeup

Nails

Jewelry

Shoes

Bows

Hairspray

Hair

Rubber Bands

Brush

Hose

Socks

Anklet

Boots

Shoes

a. Yes

b. No

Which of the following LIBNAME statements correctly assigns the libref MyMusic to the file AllMusic.xls, which is stored in the Entertainment directory of the C: drive on the Windows operating environment?

a. libname mymusic 'Allmusic.xls';

b. libname mymusic 'C:\Entertainment\Allmusic.xls';

c. libname mymusic 'C:\Entertainment\Allmusic';

d. libname mymusic 'C:\Entertainment\Allmusic' filetype='excel';

The data sets ensemble.spring and ensemble.summer both contain a variable named Blue, and Blue is not the BY variable. Which program prevents the values of the variable Blue from being overwritten when you merge the two data sets?

data ensemble.merged;
   merge ensemble.spring(keep=blue)
         ensemble.summer;
   by fabric;
run;

data ensemble.merged;
   merge ensemble.spring(blue=navy)
         ensemble.summer;
   by fabric;
run;

data ensemble.merged;
   merge ensemble.spring(rename=(blue=navy))
         ensemble.summer;
   by fabric;
run;

The variable Location appears in the three data sets represented below. Which value appears in the output data set when the three data sets are merged in the order shown?

merge dataset1 dataset2 dataset3;

dataset1

Location

Florida

dataset2

Location

Canada

dataset3

Location

New York

a. Florida

b. Canada

c. New York

Suppose the empinfo.bonuses data set contains the variables ID, Name, Office, Manager, Location, and Amount. Specify a data set option in the MERGE statement below to use only the variables ID, Name, and Amount in the data set.

data mergedata.emppay;
   merge sales.reps(rename=(office=OfficeNumber))
         empinfo.sales
         empinfo.bonuses ___________________;
   by ID;
run;

a. (drop=ID Name Amount)

b. (output ID Name Amount)

c. (keep=ID Name Amount)

d. (in=ID Name Amount)