SAS® Data Preparation

This offering adds enhancements to SAS® Viya®, including advanced data profiling features, data quality transformations for SAS Data Studio and programming interfaces for data quality operations. 

SAS Data Preparation includes Cloud Data Exchange (CDE), a data connection capability that securely copies high-volume data from an on-premises store to a cloud-based instance of SAS Viya for use in SAS Viya applications. The CDE also allows Cloud Analytic Services to read and write data stored on-premises. SAS Data Agent enables you to move data to and from the cloud.

white marble texture

The most recent release is SAS Data Preparation 2.2.

What's New

What's New in SAS Data Explorer 2.2

  • Cloud Data Exchange is available on the data sources tab.
  • New databases are supported on the data sources tab.
  • Advanced input options and unique ID columns.
  • Import feature extracts text and metadata from a collection of documents.
  • Import feature supports geocoding.
  • Improved management of tags for tables and columns.
  • New data profiling features.
  • Improved management of tables and caslibs.
  • Improved social media import performance.
  • Microsoft Windows and SAS Data Quality.

What's New in SAS Lineage Viewer for 2.2

  • Additional connection type support.
  • Improvements in performance and usability.
  • Primary relationships view type.
  • Lineage saved diagrams.
  • Modified by filter.

What's New in SAS Data Studio 2.2

  • Match and cluster transform.
  • Enhancements to the join transform.
  • Analytical partitioning transform.
  • Performance and usability improvements.
  • Unique identifier transform.
  • Microsoft Windows and SAS Data Quality.

What's New in SAS Data Quality

SAS 9.4M5 Data Quality Server and SAS Data Quality 3.4 provide the following enhancements:

  • Profile and categorize data with new functions for identification analysis.
  • Combined documentation for SAS Data Quality 3.4 and SAS 9.4M5 Data Quality Server.
  • Perform data quality operations on data in CAS.
  • Execute programs in CAS that contain data quality functions.
  • Use a new function to obtain a confidence score for locale guessing.
  • Interoperate with SSL-enabled DataFlux Data Management Server.
  • List the locales supported by the SAS QKB with the DQLOCLST procedure.
  • Synchronize results with DataFlux Data Management software.

Get Started

Ready to access, blend, shape, and cleanse data to prepare it for reporting or analytics? These SAS Data Preparation resources are a good place to start. 

Number 1

Watch videos



Number 3

Stay connected

Be a part of the community for SAS Data Preparation. We offer a variety of ways for you to interact with users and experts.

Tutorials

Browse our library of free SAS Data Preparation tutorials to learn something new or sharpen your skills.

Documentation

Find user's guides and other technical documentation for SAS Data Preparation.


SAS Data Preparation adds the following features to SAS Viya:

  • Advanced data profiling features for applications that support data profiling.
  • Data quality transformations for SAS Data Studio.
  • Programming interfaces for data quality operations.
  • Cloud Data Exchange connections.

Previous Versions

SAS Data Preparation Blogs & Communities

Connect with other SAS users by joining a users group or attending an upcoming event.

Back to Top