tailieunhanh - SAS Data Integration Studio 3.3- P5

SAS Data Integration Studio P5: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. | About the Main Windows and Wizards A Job Status Icon 15 Change management options are available from the Project drop-down menu and from pop-up menus. See also Process Library on page 23. Default SAS Application Server This pane displays the default SAS application server if you have selected one. The message No Default Application Server indicates that you need to select a default SAS Application server. If you double-click this pane the Default SAS Application Server window opens. From that window you can select a default server or test your connection to the default server. Alternatively you can select the default SAS application server from the Options window as described in Options Window on page 19. For more information about the impact of the default SAS application server see Selecting a Default SAS Application Server on page 96. User ID and Identity This pane displays the domain login user ID and metadata identity that are specified in the current metadata profile. Metadata Server and Port This pane displays the name and port of the SAS Metadata Server that is specified in the current metadata profile. Job Status Icon You can right-click this icon to display a list of the last five unique jobs that were submitted in the current SAS Data Integration Studio session and the status for each of them. Note The appearance of the icon changes to indicate changes in the status of the jobs that you submitted in the current session. The icon appearance returns to normal when you right-click the icon. A 16 Expression Builder Window A Chapters Expression Builder Window Use the Expression Builder to create SAS expressions that aggregate columns perform conditional processing and perform other tasks. For example the following display shows an expression that sums the values in a column named Total_Retail_Price. Display Expression Builder Window with a SUM Expression The Expression Builder is displayed from tabs in the property windows of many SAS Data Integration .