• Contents
  • About
  • Introduction
    • Overview of SAS Data Integration
      • About SAS Data Integration
      • Advantages of SAS Data Integration
      • A Basic Data Integration Environment
      • Online Help for SAS Data Integration Studio
      • Administrative Documentation for SAS Data Integration Studio
      • Accessibility Features in SAS Data Integration Studio
      • Upgrading from Earlier Versions
  • General User Tasks
    • Getting Started
      • Setup for SAS Data Integration Studio
      • Security for SAS Data Integration Studio
      • Main Tasks for Creating Process Flows
      • Starting SAS Data Integration Studio
      • Connecting to a SAS Metadata Server
      • Working with the Folders Tree
      • Selecting a Default SAS Application Server
      • Registering SAS Libraries
      • Working with User-Defined Formats
      • Registering Tables and Cubes
      • Specifying Global Options in SAS Data Integration Studio
      • Working with Change Management
      • Add a Note or Document to a Registered Object
      • View the Content of Notes or Documents
    • Importing, Exporting, and Copying Metadata
      • Metadata Import and Export in SAS Data Integration Studio
      • Working with SAS Package Metadata
      • Preparing to Import or Export SAS Package Metadata
      • Exporting SAS Package Metadata
      • Importing SAS Package Metadata
      • Copying and Pasting Metadata Objects
      • Working with SAS Metadata Bridges
      • Usage Notes for Importing or Exporting with a SAS Metadata Bridge
      • Preparing to Import or Export with a SAS Metadata Bridge
      • Importing New Metadata with a SAS Metadata Bridge
      • Importing Updated Metadata with a SAS Metadata Bridge
      • Exporting Metadata with a SAS Metadata Bridge
    • Working with Tables
      • About Tables
      • Registering Existing Tables with the Register Tables Wizard
      • Registering New Tables with the New Table Wizard
      • Viewing or Updating Table Metadata
      • Using a Physical Table to Update Table Metadata
      • Specifying Options for Tables
      • Supporting Case and Special Characters in Table and Column Names
      • Maintaining Column Metadata
      • Maintaining Keys
      • Maintaining Indexes
      • Browsing Table Data
      • Editing SAS Table Data
      • Using the View Data Window to Create a SAS Table
      • Specifying Browse and Edit Options for Tables and External Files
    • Working with External Files
      • About External Files
      • Registering a Delimited External File
      • Registering a Fixed-Width External File
      • Registering an External File with User-Written Code
      • Viewing or Updating External File Metadata
      • Overriding the Code Generated by the External File Wizards
      • Specifying NLS Support for External Files
      • Accessing an External File with an FTP Server or an HTTP Server
      • Viewing Data in External Files
      • Registering a COBOL Data File That Uses a COBOL Copybook
      • Using an External File in the Process Flow for a Job
    • Creating Jobs
      • About Jobs
      • Creating an Empty Job
      • Creating a Process Flow for a Job
      • Creating a Job That Contains Jobs
      • Working with Default Temporary Output Tables
      • About Job Options
      • Documenting Process Flow Diagrams
      • Accessing Local and Remote Data
      • Viewing or Updating Job Metadata
      • Displaying the SAS Code for a Job
      • Common Code Generated for a Job
    • Managing Jobs
      • About Managing Jobs
      • Submitting a Job for Immediate Execution
      • Meeting Prerequisites for Collecting Job Statistics
      • Reviewing a Successful Job
      • Diagnosing and Correcting an Unsuccessful Job
      • Maintaining Column Mappings
      • Managing the Scope of Column Changes in Jobs
      • Managing Connections in Job Editor Windows
      • Viewing the Code for a Transformation
      • Viewing or Updating the Metadata for Transformations
    • Managing the Status of Jobs and Transformations
      • About Status Handling for Jobs and Transformations
      • Default Conditions, Actions, and Conditional Action Sets
      • Prerequisites for Actions
      • Perform Actions Based on the Status of a Job
      • Perform Actions Based on the Status of a Transformation
      • Macro Variables for Status Handling
    • Deploying Jobs
      • About Deploying Jobs
      • About Deploying Jobs for Scheduling
      • Prerequisites for Deploying a Job for Scheduling
      • Deploying Jobs for Scheduling
      • Redeploying Jobs for Scheduling
      • Using Scheduling to Handle Complex Process Flows
      • Using Deploy for Scheduling to Execute Jobs on a Remote Host
      • About Deploying Jobs as Stored Processes
      • Prerequisites for Deploying a Job as a Stored Process
      • Deploying Jobs as Stored Processes
      • Redeploying Jobs to Stored Processes
      • Viewing or Updating Stored Process Metadata
      • About Deploying Jobs as Web Services
      • Prerequisites for Web Service Jobs
      • Requirements for Web Service Jobs
      • Creating a Web Service Job
      • Deploying a Web Service Job as a Stored Process
      • Deploying a Stored Process as a Web Service
    • Working with Generated Code
      • About Code Generated for Jobs
      • Displaying the Code Generated for a Job
      • Displaying the Code Generated for a Transformation
      • Specifying Options for Jobs
      • Specifying Options for a Transformation
      • Modifying Configuration Files or SAS Start Commands for Application Servers
    • Working with User-Written Code
      • About User-Written Code
      • Adding User-Written Code to the Precode and Postcode Tab
      • Adding a User Written Code Transformation to a Job
      • Creating and Using a Generated Transformation
      • Maintaining a Generated Transformation
      • Editing the Generated Code for a Job or Transformation
      • Replacing the Generated Code for a Job or Transformation
    • Optimizing Process Flows
      • About Process Flow Optimization
      • Managing Process Data
      • Managing Columns
      • Streamlining Process Flow Components
      • Using Simple Debugging Techniques
      • Using SAS Logs
      • Reviewing Temporary Output Tables
      • Additional Performance Optimization Information
    • Using Impact Analysis
      • About Impact Analysis and Reverse Impact Analysis
      • Performing an Impact Analysis
      • Performing Impact Analysis on a Generated Transformation
      • Performing Reverse Impact Analysis
    • Working with Reports
      • About Reports
      • Opening the Reports Window
      • Selecting the Reports Perspective
      • Customizing the Tables Report
      • Customizing the Job Documentation Report
      • Running and Saving a Report
      • Saving a Report As a Document Object
      • Viewing a Report
      • Creating Your Own Report
  • Working with Transformations
    • Working with Loader Transformations
      • About Loader Transformations
      • About the SPD Server Table Loader Transformation
      • About the Table Loader Transformation
      • Setting Table Loader Transformation Options
      • Selecting a Load Technique
      • Removing Non-Essential Indexes and Constraints during a Load
      • Considering a Bulk Load
    • Working with SAS Sort Transformations
      • About Sort Transformations
      • Optimizing Sort Performance
      • Creating a Table That Contains the Sorted Contents of a Source
    • Working with SQL Join Transformations
      • About SQL Join Transformations
      • Using the Designer Window
      • Reviewing and Modifying Clauses, Joins, and Tables in an SQL Query
      • Understanding Automatic Joins
      • Selecting the Join Type
      • Adding User-Written SQL Code
      • Debugging an SQL Query
      • Adding a Column to the Target Table
      • Adding a Join to an SQL Query on the Designer Tab
      • Creating a Simple SQL Query
      • Configuring a SELECT Clause
      • Adding a CASE Expression
      • Creating or Configuring a WHERE Clause
      • Adding a GROUP BY Clause and a HAVING Clause
      • Adding an ORDER BY Clause
      • Adding Subqueries
      • Validating or Submitting an SQL Query
      • Joining a Table to Itself
      • Using Parameters with an SQL Join
      • Constructing a SAS Scalable Performance Data Server Star Join
      • Optimizing SQL Processing Performance
      • Performing General Data Optimization
      • Influencing the Join Algorithm
      • Setting the Implicit Property for a Join
      • Enabling Pass-Through Processing
      • Using Properties Window Options to Optimize SQL Processing Performance
    • Working with Iterative Jobs and Parallel Processing
      • About Iterative Jobs
      • Creating and Running an Iterative Job
      • Creating a Parameterized Job
      • Creating a Control Table
      • About Parallel Processing
      • Setting Options for Parallel Processing
    • Working with Slowly Changing Dimensions
      • About Slowly Changing Dimensions
      • About Dimension Tables
      • About Fact Tables
      • Loading a Dimension Table with Type 1 and 2 Updates
      • Loading a Fact Table Using Dimension Table Lookup
      • Loading a Table and Adding a Surrogate Primary Key
      • Tracking Changes in Source Datetime Values
      • Closing Out Rows in Datetime Change Tracking
    • Working with Change Data Capture
      • About the Change Data Capture Transformations
      • About CDC Changed Data Tables
      • About CDC Control Tables
      • Capture Changed Data from Oracle
    • Working with Message Queues
      • About Message Queues
      • Prerequisites for Message Queues
      • Selecting Message Queue Transformations
      • Processing a WebSphere Queue
      • Polling a Websphere Message Queue
      • Processing a Microsoft Queue
    • Working with SPD Server Cluster Tables
      • About SPD Server Cluster Tables
      • Creating an SPD Server Cluster Table
      • Maintaining an SPD Server Cluster
  • Appendixes
    • Main Windows and Wizards
      • Analysis Window
      • Checkouts Tree
      • Code Editor
      • Comparison Results Window
      • Connection Profile Window
      • Desktop
      • Details Pane
      • Expression Builder
      • Folders Tree
      • Inventory Tree
      • Job Editor
      • Properties Windows
      • Reports Window
      • Tools-Options Window
      • Transformations Tree
      • Tree View
      • View Data Windows
      • Wizards
    • Java Code and Methods for Report Plug-ins
      • Example Java Code for a Report Plug-in
      • Reporting Interface Methods
  • Glossary


ProductRelease
SAS Data Integration Studio Server Data9.2
SAS Data Integration Studio4.2
SAS Enterprise Data Integration Server4.2
SAS Data Integration Server4.2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
02Jul2009