SAS^® Studio

Build efficient data pipelines with a world-class data engineering experience

Screenshot of SAS Studio no code with highlights

SAS Studio

Seamless collaboration. Low-code brilliance. Open source integration.

Access any data – on-premises or in the cloud.

Connect to leading cloud data platforms, such as AWS Redshift and S3, Google BigQuery and Cloud Storage, Azure Data Lake storage. SAS Studio also connects to relational and nonrelational databases – Oracle, Snowflake, Teradata, SingleStore, MongoDB and others – and various file formats, such as Excel, Text, Parquet and ORC.
Choose your path: No code, low code or, yes, code.

Create end-to-end data pipelines using a wide collection of powerful steps in a drag-and-drop interface. Develop your Python and SAS code assets within SAS Studio or any other IDE. Then seamlessly embed them into SAS Studio flows to ensure centralized, secure access to data sources, single pane of glass for your data flows and a governed auditable execution environment.
Choose your style: Integrate data in ELT or ETL manner.

Create data integration processes in an ELT or ETL approach. Get the best performance from powerful in-database transformations to join, transform and merge data, and implement slowly changing dimensions. You can also enable ETL processing on an application server. Or use a combination of both.
Create your own visual transformations for unique needs.

A visual drag-and-drop designer lets you create your own powerful custom transformations, share them across data teams and use custom steps in data flow or standalone. Explore a variety of community-built transformations in the public SAS Studio Custom Steps GitHub repository.
Streamline, boost and govern data team collaboration.

Efficiently manage and orchestrate your project assets by using advanced Git integration for resolving code and logic changes, enabling versioning and change history tracking across multiple data engineers. Serve data easily with open documented APIs.
Integrate with open source technologies wisely.

Schedule, orchestrate and monitor your data pipelines with Apache Airflow with SAS Provider for Airflow or any other tools. Bring your Python code in governed enterprise workflows. Wrap up siloed open source utilities into visual steps with a custom steps framework.

Get to know SAS Studio with these tutorials

Recommended Resources

Graphic of blue dots on black space

Webinar

Advance Your Data Engineering and Analytics Skills With SAS Studio on SAS Viya Catalog

Webinar

SAS Studio Flows and Steps

Young coworkers working together at desktop computer

Video

Migrating SAS Enterprise Guide Project to SAS Studio Flows

Young businessman with laptop

Video

Migrating SAS Data Integration Studio Jobs to SAS Studio Flows

View more data management resources