Products & Solutions / Data Quality

SAS® Data Quality Solution

Ensuring information excellence through data quality lifecycle management

SAS Data Quality Solution provides an enterprise solution for profiling, cleansing, augmenting and integrating data to create consistent, reliable information. With SAS Data Quality Solution you can automatically incorporate data quality into data integration and business intelligence projects to dramatically improve returns on your organization’s strategic initiatives.

Benefits

  • Improve key data areas through data quality profiling.
  • Achieve a unified, accurate view of data.
  • Support changing business needs through customization.
  • Provide decision makers with trustworthy information.

Read more

Features

Read more

Screenshots

SAS Data Quality Solution provides an easy-to-use interface that lets you uncover inconsistencies and inaccuracies in your data.

Screenshot: SAS Data Quality Solution provides an easy-to-use interface that lets you uncover inconsistencies and inaccuracies in your data.
More ScreenshotsEnlarge
 

How SAS® Is Different

  • Runs on multiple mainframe and PC operating systems.
  • Delivers unmatched ease of use and deployment.
  • Supports both business users and IT staff users.
  • Quality Knowledge Base requires no programming knowledge; it has built-in phonetics and heuristic algorithms used for matching and cleansing.

Benefits

  • Improve key data areas through data quality profiling. Profiling capabilities allow you to determine where potential problems exist and what efforts will be required to rectify them. You can then focus on root cause analysis, improving key data areas and processes for better planning and project execution.
  • Achieve a unified, accurate view of data. With SAS Data Quality Solution, organizations can incorporate data quality business rules across data sources and platforms. By implementing standard and custom processes, data from different systems can be regulated and standardized into a unified, accurate view.
  • Support changing business needs through customization. Specialized interfaces make it easy to create and change data quality rules according to business needs, as well as visualize the impact of those rules. State-of-the-art tools enable thorough execution of the data quality processes that you define.
  • Provide decision makers with trustworthy information. Accurate, consistent, valid and reliable data delivers consistent reporting and analytic results. By automatically integrating data quality into data integration processes, you ensure that data used for business intelligence and analytics will be current and accurate.

Features

Data profiling capabilities
  • Analyzes enterprise data to determine nuances, discrepancies and inaccuracies in data.
  • Provides an easy-to-use interface to determine areas of poor data quality and the amount of effort required to rectify them.
Cleansing and standardization
  • Provides the ability to eliminate or reduce inconsistencies in corporate data.
  • Provides easy-to-use tools to analyze and prototype data quality cleansing processes and correct data accordingly.
Matching and deduplication
  • Consolidates data from multiple data sources when a complete match is not possible.
  • Creates unique key values by using fuzzy logic to group together information with similar values across one or multiple fields
Identification analysis
  • Determines the gender of an individual for targeted marketing purposes.
  • Determines whether a value is a person or an organization.
Data quality rule customization
  • Personalize parsing, matching and standardization algorithms.
  • Create or enhance the rules used to parse the parts of the names, addresses, e-mail addresses, product codes and other business data.
  • Add rules to matching algorithms about which part of a data string weighs the heaviest in a match.
  • A common Quality Knowledge Base (QKB) lets you share this information between SAS products (server) and DataFlux® products (clients).
International support
  • Understands the nuances in various languages, including names, addresses, organizations and other areas where data parsing is required.
  • Employs local knowledge of these data types.
A component of SAS Data Integration
  • By integrating with SAS capabilities, SAS Data Quality Solution can be part of an overall data integration strategy.
  • Data quality can be applied to all SAS supported data sources and platforms, which ensures enterprise scalability.
  • Provides an interactive approach to data quality that eliminates duplication of effort when creating business rules.

Screenshots

SAS Data Quality Solution provides an easy-to-use interface that lets you uncover inconsistencies and inaccuracies in your data.

SAS Data Quality Solution provides an easy-to-use interface that lets you uncover inconsistencies and inaccuracies in your data, and its robust server environment gives you the power to analyze data quality across your entire organization.

Enlarge

System Requirements

Client environment

  • Windows (x86-32): Windows XP Professional, Windows Vista*


Server environment

  • AIX: Version 5.3 and Version 6.1 on POWER architectures
  • HP-UX PA-RISC: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • HP-UX Itanium: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • Linux for x86 (x86-32): RHEL 4, SuSE SLES 9
  • Linux for x64 (EM64T/AMD64): RHEL 4, SuSE SLES 9
  • Microsoft Windows (x86-32): Windows Server 2003 family
  • Microsoft Windows on x64 (EM64T/AMD64): Windows XP Professional for x64, Windows Vista* for x64, Windows Server 2003 for x64
  • Solaris on SPARC: Version 9, 10
  •  Solaris on x64: Version 10
  • z/OS: V1R7, V1R8, V1R9 and higher

* NOTE: Windows Vista editions that are supported include Enterprise, Business and Ultimate.


Required software

  • Base SAS® 


Optional software

  • SAS Data Integration Server (for data quality transformation plug-ins)
  • SAS/ACCESS® software (for access to third-party databases)
  • Additional Quality Knowledge Base (QKB) locales
  • dfPower Verify (CASS, SERP, US Geocode, Canadian Geocode, phone and ZIP code analysis, and world address verification)
  • dfPower Monitor (real-time business rule monitoring)
  • dfPower Explorer (metadata profiling)


SAS Data Quality Solution is also included as part of SAS Enterprise Data Integration Server.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.