Using ODS to Specify Output from the XML Writer

Problem

You want to change how the output of the XML Writer transformation is displayed.

Solution

You can use an Output Delivery System (ODS) tagset to change the output. You cannot use an XML Map because the SAS XML LIBNAME statement does not support XML Maps for write operations. You must be familiar with ODS and the general steps for editing jobs in SAS Data Integration Studio. For more information about ODS, see the SAS Output Delivery System: User's Guide.

Tasks

Specify an ODS Tagset for the XML Writer Transformation in a Job

Perform the following steps to edit the ODS tagset for the XML Writer Transformation in a job.
  1. Open the properties window for the XML Writer transformation.
  2. Click the Precode and Postcode tab.
  3. Select Precode.
  4. Edit the sample ODS tagset that is displayed in the Precode field.
  5. Click Save As on the toolbar for the Precode and Postcode tab to access the Save As window.
  6. Select Metadata to save the ODS tagset as metadata.
  7. Click OK to save the tagset and return to the Precode and Postcode tab.
  8. Click OK to close the properties window for the XML Writer transformation.
After you have specified an ODS tagset, you can run the job and verify the output.