Example 9.5 Creating Columns That Contain the Attributes of Other Columns
Create a table that has metadata for columns in specific tables. Determine the name, type, length, label, and format of the columns and designate these as columns in the new table.
|Featured Step||PROC SQL|
|Featured Step Options and Statements||DICTIONARY tables COLUMNS and TABLES Subqueries|
|A Closer Look||Accessing SAS System Information Using Dictionary Tables|
Tables TRIAL3_WEEK01, TRIAL3_WEEK02, TRIAL3_WEEK04, and TRIAL3_WEEK08 contain medical information for two patients in a clinical trial. The tables have a combination of variables that are in common and that are unique among the four tables. Assume the tables are saved in a library that ...