Example 3.5 Combining Multiple Tables When the Matching Column Has Different Attributes
Combine multiple tables where the matching column has different attributes such as length and can be stored as either numeric or character.
|Featured Step||PROC SQL|
|Featured Step Options and Statements||FULL OUTER JOIN COALESCE function Subquery|
|Related Technique||PROC SORT and DATA step match-merge|
Table WEBCLASSES contains information about six classes. Table CLASS_UPDATES contains updates on some of the classes in WEBCLASSES, and it includes new classes. Table WEBCLASS_SCHEDULE contains scheduling information for classes and their section in fall 2009.
Column CLASSID is in common among the three tables. However, it is defined ...