SAS^® Data Quality Accelerator for Teradata Features

Casing

• Ensures context-appropriate casing is used in a data column.

Extraction

• Extracts context-specific entities or attributes from text string.

Gender analysis

• Determines the gender of a name.

Identification analysis

• Determines the type of data represented by a text string.

Parsing

• Segments a string into separate, discrete entities.

Pattern analysis

• Shows simple representation of a text string's character pattern. It's useful to determine if further data quality processing is necessary.

Standardization

• Outputs a preferred format for all the values in a column for uniformity.

Matchcode generation

• Generates a “matchcode” for a text string. A matchcode is used for fuzzy matching comparisons between related but not identical information.