Example 5.1 Adding Values to All Observations in a Data Set
Combine summary statistics that are saved in a single observation in one data set with all observations in another data set. Compute new variables based on the values of the summary and detail information.
|Featured Step||DATA step|
|Featured Step Options and Statements||IF _N_=1 statement|
|Related Technique||PROC SQL, Cartesian product|
|A Closer Look||Understanding How the DATA Step Adds Values from an Observation in One Data Set to All Observations in Another|
Input Data Sets
The first 10 of 200 observations in STUDENTS are listed.
PROC MEANS created data set OVERALL by analyzing variable SCORE in data set STUDENTS. The 10th percentile and 25th percentile statistics for SCORE ...