The two SORT procedures tell SAS to sort the demog and status data sets by the variable subj, and to store the results, respectively, in data sets called descdemog and descstatus. a match-merge in which the observations in the first data set to be merged matches one or more observations in the second data set to be merged.a match-merge in which the data sets to be merged share, aside from the variable that links the data sets together, at least one common variable name.a match-merge in which the data sets to be merged contain a different number of observations, and each observation in the first data set matches with no more than one observation in the second data set.a match-merge in which the data sets to be merged are sorted by the BY variable in descending order.a match-merge in which the data sets to be merged contain the same number of observations, and each observation in the first data set matches with exactly one observation in the second data set.In increasing order of complexity, the situations are: Throughout the rest of this section, we will look at examples of match-merges under various situations. One thing to keep in mind, though, is you can't match-merge SAS data sets unless they are sorted by the variables appearing in the BY statement. To match-merge, you simply specify the data sets you would like to merge in a MERGE statement, and indicate the variables on which you would like to merge in a BY statement.
As you can see, the observations in the baby data set are created by joining observations from the bird and bee data sets that share the same year.
0 kommentar(er)
