SAS Data Integration Studio P31: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. | Registering Data Targets A Specify Physical Storage Information for the New Table 145 Specify Physical Storage Information for the New Table Use the physical storage window to specify the format and location of the table that you are registering as shown in the following display. Display Physical Storage Window In this window you specify the database management system that is used to create the target the library where the target is to be stored and a valid name for the target. Follow these steps 1 Because the target is a SAS data set in the DBMS field accept the default value of SAS. 2 In the Library field use the selection arrow to select Report Table Lib. 3 In the Name field enter a valid SAS name for the target. For details about SAS names see the SAS Data Integration Studio Help. For this example accept the default Total_Sales_By_Employee. 4 When you are finished specifying physical storage information click Next. The Custom tree group selection window displays. Usage Hints for the Physical Storage Window Remember the following as you use the physical storage window The name that you specify in the Name field must follow the rules for table names in the format that you select in the DBMS field. For example if SAS is the selected DBMS the name must follow the rules for SAS data sets. If you select another DBMS the name must follow the rules for tables in that DBMS. For a SAS table or a table in a database management system you can enable the use of mixed-case names or special characters in names. See Setting Name Options for Individual Tables on page 109. You can specify new libraries or edit the metadata definitions of existing libraries using the New and Edit buttons. 146 Specify a Custom Tree Group for the Current Metadata za Chapter 9 You can use the Table Option button to specify options for SAS tables and tables in a DBMS. Specify a Custom Tree Group for the Current Metadata Use the Select Group window to specify a Custom tree group for the table that
