Step-by-Step Programming with Base SAS 9.4

Combining Selected Observations from Multiple Data Sets

To create a data set that contains only the observations that are selected according to a particular criterion, you can use the subsetting IF statement and a SET statement that specifies multiple data sets. The following DATA step reads two input data sets to create a combined data set that lists only the winning teams:

data champions(drop=result);1
   set southamerican (in=S) european;2
   by Year;
   if result='won';  3
   if S then Continent='South America';  4
   else Continent='Europe';
run;

proc print data=champions;
   title 'World Cup Champions from 1954 to 1998';
   title2 'including Countries'' Continent';
run;

The following list corresponds to the numbered items in the preceding program:

1

The ...