SAS Data Integration Studio P37: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. | Example Process Flows A Create and Populate the New Job 175 Metadata for the source table a SAS data set called TigersHitting2002 is available in a current metadata repository. Output for the report will be sent to the Output tab in the Process Designer window. The appropriate option must be set so that the Output tab appears in the Process Designer window. For details see Process Designer Window on page 20. The main metadata repository is under change-management control. You do not have to check out the metadata for the TigersHitting2002 table. The metadata for this table will not be updated. 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 TigersHitting2002 table that are used in the job. It is assumed that you have started SAS Data Integration Studio and have opened the appropriate metadata profile. For this example the appropriate metadata profile would specify the repository that will enable you to access the PrintHittingStatistics transformation and the metadata for the source table which is TigersHitting2002. Create and Populate the New Job Follow these steps to create a complete process flow diagram from sources through transformations to targets 1 2 3 4 5 6 From the SAS Data Integration Studio menu bar select Tools Process Designer. The New Job wizard displays. Enter PrintHittingStats Job in the Name field. Then enter a description for the job in the Description field. Click Finish. An empty job will open in the Process Designer window. The job has now been created and is ready to be populated with the PrintHittingStatistics transformation template and the source table TigersHitting2002. On the SAS Data Integration Studio desktop click the Process tab to display the Process Library. In the Process Library open the UserDefined folder and the Reports subfolder. Click hold and drag the PrintHittingStatistics transformation into .
