SAS Data Integration Studio P26: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. | 120 Example Using a Source Designer to Register SAS Tables A Chapters Example Using a Source Designer to Register SAS Tables Preparation Suppose that you wanted to create a report that extracted information from three operational tables CUSTOMER ORDERS and ORDER_ITEM. Your first task would be to register these tables so that they can be included in a job that creates the report. Because these tables exist in physical storage you could use a source designer wizard to register these tables. Assume that the following preparations have been made All of the tables are in SAS format and are stored in a SAS library named Ordetail. The Ordetail library has been registered in a current metadata repository. For details registering libraries see Registering Libraries on page 59. You have selected a default SAS application server for SAS Data Integration Studio as described in Selecting a Default SAS Application Server on page 96. This server can access the tables that you want to register. The main metadata repository is under change-management control. In the current example after you register the tables you must check in their metadata. For details about change management see Working with Change Management on page 113. Start SAS Data Integration Studio and Open the Appropriate Metadata Profile Follow these steps to begin work in SAS Data Integration Studio 1 Start SAS Data Integration Studio as described in Starting SAS Data Integration Studio on page 93. 2 Open the appropriate metadata profile as described in Opening a Metadata Profile on page 95. You do not need to check out a library in order to add metadata about tables in that library. Accordingly the next task is to select the appropriate source designer. Registering Data Sources A Select the SAS Source Designer 121 Select the SAS Source Designer From the SAS Data Integration Studio menu bar select Tools Source Designer. The Source Designer selection window displays as shown in the following display. Display .
