SAS Data Integration Studio P29: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 Sources A Define the Columns for the External File Metadata 135 sample data that is processed by the guessing function. The results are accurate for this particular set of records but you should still examine them to make sure that they are representative for employee dependent account records in general. The following display shows the completed Column Definitions window. Display Corrected Column Metadata 8 To verify that the metadata you have entered is appropriate for the data in the external file click the Data tab and then click Refresh. If the metadata matches the data the data displays properly on the Data tab. If the data does not display properly update the column metadata and click Refresh to verify that the appropriate updates have been made. To view the code that will be generated for the external file click the Source tab. To view the SAS log for the generated code click the Log tab. The code that displays on the Source tab is the code that is generated for the current external file when it is included in a SAS Data Integration Studio job. 136 Define the Columns for the External File Metadata A Chapters 9 Click Next. The Select Group window displays. Display Select Group Window For this example assume that you do not want to specify a Custom Tree group for the table. Select Foundation and click Next. The General window displays. You have the option to enter a name and description for the external file metadata as shown in the following display. Display General Window Registering Data Sources A View the External File Metadata 137 If you leave the Name field blank the file is identified by its path. 10 Click Finish to save the metadata and exit the wizard. View the External File Metadata After you have generated the metadata for an external file you can use SAS Data Integration Studio to view and possibly make changes to that metadata. For example you might want to remove a column from a table or change the data type of a
