SAS Data Integration Studio P30:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | 140 Example Using the Target Table Designer to Register SAS Tables A Chapter 9 Example Using the Target Table Designer to Register SAS Tables Preparation Suppose that you wanted to create a report that shows which sales person is making the most sales as described in Which Salesperson Is Making the Most Sales on page 45. You decide to extract columns from several existing tables write that information to a new table and run a report on the new table. An example of this report is shown in the following display. Display Total Sales by Employee Report Name Total Revenue Emp ID Job Title Company Dept Section Group Alban Kingston 5 120170 Sales Rep II Orion France Sales Sales Racket Sports Andre Noel 4 12D411 Sales Rep I Orion France Sales Sales Winter Sports Giulia Buono 6 120599 Sales Rep II Orion Italy Sales Sales Children Sports One way to create a new table whose columns are extracted from existing tables is to create a job that joins the required tables and writes the output of the join to a new table. The new table would be the input to a report transformation. An example of such a process flow is shown in Display on page 153. However in order to create this process flow you must first register both the source tables and the new target table. SAS Data Integration Studio needs the target table metadata to specify the content and structure of the information that is extracted from the source tables. This example describes how to use the Target Table Designer wizard to register a new table whose columns are modeled after the columns in several existing tables. Assume that the following preparations have been made The sales report will be based on a new table that is named Total_Sales_By_Employee. This table will have the same columns in the same order as the report that is shown in Display on page 140. Total_Sales_By_Employee will be created by a SAS Data Integration Studio job that joins two existing tables ORDER_FACT and .
