Databases Reference
In-Depth Information
5 Correct the metadata and resubmit the job until there are no more errors.
6 After the job runs without error, save the job. Select File ￿ Save from the menu
bar.
The next task is to verify that the job created the correct output.
Verify the Contents of the Total_Sales_By_Employee Table
The data that was loaded into the Total_Sales_By_Employee table should be
appropriate for the report that you want to create (Display 10.1 on page 150). To view
data in the Total_Sales_By_Employee table, select the table, then select View ￿ View
Data from the menu bar. The View Data window opens, as shown in the following
display.
Display 10.11 Contents of the Total_Sales_By_Employee Table
The data in the Total_Sales_By_Employee table appears to be appropriate for the
report. The next task is to add a report transformation to the end of the process flow.
Add the Publish to Archive Transformation to the Process Flow
The Publish to Archive transformation generates a SAS package file and an optional
HTML report. The package file can be published by SAS programs that use the
publishing functions in SAS Integration Technologies software.
Follow these steps to add the Publish to Archive transformation to the process flow:
1 From the SAS Data Integration Studio desktop, click the Process tab to display
the Process Library.
 
Search WWH ::




Custom Search