Standardizing Values with a Definition

Problem

You want to standardize an element within a text string. For example, you might want to change all instances of “Court” to “Ct.” but only when “Court” is used as a street suffix.

Solution

Get detailed information about the values that you want to change. Use that information to create a standardization definition that specifies the target element and maps old values to the new values. Use the definition in a SAS Data Integration Studio job to standardize the data in the appropriate columns.
In general, you would do the same tasks that are described in Standardizing Values with a Standardization Scheme. The main differences are as follows:
  • Use DataFlux Data Management Studio to create a standardization definition that specifies the target element and maps old values to the new values. For more information about creating standardization definitions, see the standardization definition topics in the “Customize” chapter of the DataFlux Data Management Studio User’s Guide. One way to find these topics is to display the help for DataFlux Data Management Studio. Click the Search tab in the left panel, then search for “standardization definition.”
  • Use SAS Data Integration Studio to create a job that includes a Standardize with Definition transformation. This transformation applies one or more standardization definitions to one or more columns in a source table.