
Chapter 2: Reading, Combining, and Managing Data for Later Analysis 63
Display 2.34 An inner join of the three SMSA subset data sets using PROC SQL
data SMSA_subset_weather;
length city $ 27;
input city & JanTemp JulyTemp RelHum Rain;
datalines;
Akron, OH 27 71 59 36
Albany-Schenectady-Troy, NY 23 72 57 35
Baltimore, MD 35 77 55 43
Allentown, Bethlehem, PA-NJ 29 74 54 44
Atlanta, GA 45 79 56 47
;
run;
data SMSA_subset_demog;
length city $ 27;
input city & Mortality Education PopDensity
pct_NonWhite pct_WC pop pop_per_house income;
datalines;
Akron, OH 921.87 11.4 3243 8.8 42.6 660328 3.34 29560
Albany-Schenectady-Troy, NY 997.87 ...