Module 10 Lesson 1 PPT : Chapter 19: Combining SAS® Data Sets

b No, these data sets do not share one common variable. Therefore, they cannot be combined in a single DATA step.

Any number of data sets can be merged in a single DATA step. However, the data sets must have a common variable and be sorted by that variable. Do the following data sets have a common variable? a.Yes b.No

First.Customer_ID and Last.Customer_ID

What two temporary variables are created due to the BY statement?

d

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 you use the MERGE statement with the BY statement, the data must be sorted or indexed on the BY variable.

b

Which statements access the Supplier worksheet in the Excel workbook correctly?

data combine; merge products(in=InProd) costs(in=InCost); by ID; if InProd=0 or InCost=0; run;

Write the appropriate IF statement to create the desired data set that contains only non-matches.

Match-merging combines

observations from one or more SAS data sets into a single observation in a new data set, based on the values of one or more common variables.