SAS® Data Preparation

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

Watch this high-level overview of the capabilities and functionality of SAS Data Preparation.
In only 60 seconds, get the highlights of how SAS Data Preparation can help you to quickly prepare data for analytics.
Number 2

Learn the basics

These tutorials can help you learn more about SAS Data Preparation:

View all tutorials
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.

SAS Community Denmark Grafik

Tutorials

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

Learn how to leverage SAS Data Explorer to profile data for inconsistencies and anomalies.
Watch a demonstration of the profiling power of SAS Data Preparation.

Loading Data

Profiling Data

Displaying Lineage

Preparing Data

white marble texture

Training Courses

Learn SAS technology quickly and efficiently by taking a course from the analytics experts.


Self-Service Data Preparation in SAS® Viya®

This course provides an overview of the analytic data preparation capabilities of SAS Data Preparation in SAS Viya. These self-service data preparation capabilities include bringing data in from a variety of sources, preparing and cleansing the data to be fit for purpose, analyzing data for better understanding and governance, and sharing the data with others to promote collaboration and operational use.
Learning path for SAS Viya

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

2.1

SAS Data Preparation Blogs & Communities

Content is loading
Read the blog
Content is loading
Find your community

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

Get Help

Search Knowledge Base

Start here to find answers quickly, without having to open a support track.

Ask SAS Community

Interact with other SAS users to ask questions and get answers.

Contact Technical Support

Get  technical support for your SAS software via our support track system.

Back to Top