Example 3.10 Generating Every Combination of Rows between Tables Based on a Common Column
Combine two tables that have a common column where the common column has duplicate values in both tables. Produce a table that contains all possible combinations of the rows where the values from the common column match.
|Featured Step||PROC SQL|
|Featured Step Options and Statements||Full join with WHERE clause|
|Related Technique||Hash iterator object in the DATA step|
Table MEETINGS contains events to be held on two days and the expected attendance for each event. Table MEETINGROOMS contains meeting rooms that are available for the same two days. The column in common between the two tables is MEETINGDATE with multiple occurrences ...