Databases Reference
In-Depth Information
4
Select the metadata for the desired table or external file, then select
View
View
Data
from the menu bar. The View Data window displays the data in the table or
file. Verify that the content, format, and column headings are what you expected.
View Data in a Transformation's Temporary Output Table
If a target table in a process flow does not contain the data that you were expecting,
you might want to verify that the inputs to that target table are correct. The most
immediate input to the target table is the temporary output table of the preceding
transformation in the process flow. Use the View Data window to display data in the
temporary output tables for a transformation in a job, if the transformation creates
temporary output tables.
Note:
To view the temporary output tables for a transformation, you have to execute
the job and view the temporary tables in the same session of the Process Designer
window. The temporary output tables for transformations are deleted when you close
the Process Designer window.
The following steps describe one way to display data in the temporary output tables
for a transformation in a job:
1
On the SAS Data Integration Studio desktop, select the
Inventory
tab.
2
In the Inventory tree, expand the
Jobs
folder.
3
Select the desired job, then select
View
View Job
from the menu bar. The
process flow diagram for the job displays on the
Process Editor
tab in the
Process Designer window.
4
Execute the job. (The transformation must have been executed at least once in
order for the temporary output tables to exist in physical storage.) Select
Tools
Submit
from the menu bar.
5
Select the metadata for the desired transformation, then select
View
View
Data
from the menu bar. The View Data window displays the data in the
temporary output table for a transformation. Verify that the content, format, and
column headings are what you expected.
See also “Analyzing Transformation Output Tables” on page 192.
Viewing Metadata
Viewing Metadata for Jobs
Overview
Use the property window for a job to view its basic metadata. For example, you can
find out if user-written code has been specified for the entire job, or if any code is
supposed to run before or after the job. For a description of the job properties window,
see “Job Properties Window” on page 17.
Search WWH ::
Custom Search