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 ...