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.