Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
SAS Data Integration Studio 3.3- P28: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.: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. | 130 Set Delimiters and Parameters A Chapters Set Delimiters and Parameters Follow these steps to set delimiters and parameters for the external file 1 Deselect the Blank check box in the Delimiters group box. Then select the Comma check box as shown in the following display. This step is necessary because the Blank check box is selected by default. However the employeeFlatFile.csv file is comma-delimited. This change ensures that the wizard parameters match the incoming data. Display 8.9 Delimiters and Parameters Window 2 Accept the remaining defaults and click Next. The Column Definitions window displays. Registering Data Sources A Define the Columns for the External File Metadata 131 Define the Columns for the External File Metadata Follow these steps to create column definitions for the external file 1 Click Refresh to view the data from employeeFlatFile.csv on the File tab in the view pane at the bottom of the window as shown in the following display. Display 8.10 Delimited Data in the Column Definitions Window 132 Define the Columns for the External File Metadata za Chapters 2 The next step populates preliminary data into the columns component of the Columns Definitions window. To begin click Auto Fill. The Auto Fill Columns window displays as shown in the following display. Display 8.11 Auto Fill Columns Window 3 Change the value that was entered in the Start record field in the Guessing records group box to 2. This setting ensures that the guessing algorithm begins with the second data record in the external file. The first data record in the file is unique because it holds the column names for the file. Thus all data that it contains uses the character data type. The other rows in the file begin with a character-based name but the remaining values are numeric. Therefore excluding the first data from the guessing process yields more accurate preliminary data. 4 Accept all of the remaining default settings. Then click ok to return to the Column Definitions .
