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.

The most recent release is SAS Data Preparation 2.5.

What's New in SAS Data Explorer 2.5

New data sources are available, including S3, ADLS, Snowflake, MongoDB, Google BigQuery, and Salesforce.
You can download an in-memory table to a delimited file on your computer.
You can merge content from multiple tables or files in a directory and load it to an in-memory table for analysis.
You can copy a table in one format to another format.
You can import a snapshot of a project on a SAS Event Stream Processing server.
You can automate data management with the SAS Data Explorer CLI.

What's New in SAS Lineage Viewer for 2.5

No new enhancements in this release.

What's New in SAS Data Studio 2.5

Ability to Select the Format When You Save Target Tables
Double Data Type Available for Match and Cluster Transform Cluster ID
Interface Updates
Manage Columns Transform
Remove Duplicates Transform
Save as In-Memory Table Only Check Box
Simple Random Partitioning Method
Suggestions Feature

What's New in SAS Data Quality 3.5

DS2 support for some data quality functions
Profiling capabilities through PROC DATAMETRICS

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.

Watch videos

Learn the basics

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

View all tutorials

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.

Loading Data

Profiling Data

Displaying Lineage

Preparing Data

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.