SAS Products
SAS® Data Preparation
SAS Data Preparation is a software offering that adds these 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 (CDE) is a data connection capability for SAS Data Preparation on SAS Viya. Cloud Data Exchange securely copies data from an on-premises data store to a cloud-based instance of SAS Viya for use in SAS Viya applications. CDE performs high-volume data transfer from on-premises to SAS Viya in support of big data. A command-line interface (CLI) is also provided for administration and control of the customer data.
Cloud Data Exchange also allows Cloud Analytic Services (CAS) to read and write data stored on-premises. On-premises can be one or more deployments, all associated with one and the same SAS Viya full stack deployment. SAS Data Agent provides the means to move data to and from the cloud.
SAS Data Agent is the server that provides the environment to move data. You can deploy SAS Data Agent locally, on-premises, or in a cloud environment. A CLI is used to create definitions such as data services and data source names. The CLI is also used to define security domains for accessing data sources that are located on-premises.
The most recent release is SAS Data Preparation 2.2.
New to SAS Data Preparation? Check out the SAS Data Preparation Learning Center.
News for SAS Data Preparation
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
- New Import Feature Extracts Text and Metadata from a Collection of Documents
- New 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
- 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
- Additional Connection Type Support
- Improvements in Performance and Usability
- Primary Relationships View Type
- Lineage Saved Diagrams
- Modified By Filter
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
Free Online Documentation
SAS Data Preparation 2.2
- SAS Data Preparation 2.2 documentation
- SAS Data Explorer 2.2 documentation Updated September 2018
- SAS Data Studio 2.2 documentation Updated September 2018
- SAS Lineage Viewer 2.2 documentation
- SAS Data Quality 3.4 documentation
All online documentation for supported releases of SAS Data Preparation.
Cloud Data Exchange 2.3
- SAS Data Agent 2.3 for Linux: Deployment Guide
- Cloud Data Exchange 2.3 for SAS Viya 3.4: Administrator's Guide
All online documentation for supported releases of Cloud Data Exchange.
Need help?
SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-0025, option 4 or e-mail.
Training
Need help?
Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-727-0025, option 4 or e-mail.
International customers, please contact your country office.
Videos
SAS Data Preparation Video Library
- Using SAS Data Explorer to Import Local Files
- Using SAS Data Explorer to Profile Data For Better Understanding
- Using SAS Data Explorer to Load SAS Data Sets
- Using SAS Data Explorer to Load Relational Database Tables
- Using SAS Data Quality to Cleanse Data into a Consistent and Reliable Format
- Using SAS Data Studio to Prepare and Transform Data into the Desired Format
- Using SAS Lineage Viewer to Manage and Govern Data Assets and Their Relationships
Online Support Resources
Visit the Technical Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support form.
 |
Data Management CommunityShare your experiences, questions and ideas with other SAS Data Management Community users. |