No more typing reviews! Try our Samantha, our new voice AI agent.

SAS Enterprise Guide pros and cons

Vendor: SAS

4.1 out of 5

24 reviews
89% willing to recommend

Pros & Cons summary

SAS Enterprise Guide provides extensive statistical functionality and basic database interactions for business users without SQL or data analysis backgrounds. It enables effective data management, advanced SAS programming, and collaborative work environments. Users can join tables, create columns, and use data for operational needs such as fraud detection. However, performance issues occur with large Netezza database tables, and integration with open-source tools and deployment capabilities requires improvement. Users often need to learn some SAS code.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

SAS Enterprise Guide facilitates statistical functionality and basic database operations for business users without SQL or data analysis skills.

It supports robust data operations such as joining tables, creating columns, and analyzing data for purposes like fraud detection.

SAS Enterprise Guide excels in importing and exporting data, making tasks like exporting datasets from Unix to Excel simpler compared to Base SAS.

The tool enables effective collaboration, allowing users to work on servers, copy datasets, and easily share them with team members.

It is versatile, supporting various tasks including ETL processes, unit testing, functional testing, and data science projects.

CONS

Users experience challenges with performance, particularly with large datasets in the Netezza database.

There is a need for improved integration and deployment capabilities, including easier creation and export of SAS packages, and connections with R and Python.

Integration with schedulers in hosted environments like Citrix is desired.

Advanced functions often require learning SAS code, making it less user-friendly for some users.

The stability and technical support response times have been concerns for users.

SAS Enterprise Guide Pros review quotes

reviewer2232579

Data Analyst at a financial services firm with 10,001+ employees

Jul 12, 2023

One of the features of the SAS Enterprise Guide is that it has a server, and we can access the server.

Read full review

OL

Data Engineer at Ministry of Health New Zealand

Oct 19, 2022

Enterprise Guide is much better at generating reports than many solutions. We often use it to generate reports, and people interpret them how they like. They often probably use Excel spreadsheets or something like that after they get our data.

Read full review

JR

IT Administrator with 1-10 employees

Jun 15, 2022

Similar to Microsoft Access, you can drag and drop. You can simply drag and drop objects onto the page and create various flows to establish your query within the project. You can extract those queries from the preview as needed.

Read full review

SAS Enterprise Guide

Free Report: SAS Enterprise Guide Reviews and More

Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.

893,221 professionals have used our research since 2012.

reviewer1734420

Head of Customer Intelligence & Research at a financial services firm with 5,001-10,000 employees

May 4, 2022

The data cleaning part is valuable. SAS is a very powerful tool to work with and connect with different sources. We have several tables, and we are looking up tables from one place to another place. We are connecting with different data sources. The data is not coming from one source. There are several sources of data, and we have information coming from different sources. There are some flat files, and there is some information from the data warehouse.

Read full review

Karunakar Kankata

Data Scientist at a tech services company with 1,001-5,000 employees

Oct 10, 2023

It streamlines our workflow involving multiple steps, from data extraction to modeling, and it is aimed at improving various aspects of banking operations, including customer retention and risk management.

Read full review

reviewer1640493

Senior Manager, Data Science and AI / ML Manager at a tech vendor with 10,001+ employees

Jun 23, 2022

We are using SAS Enterprise Guide on a basic level and the Pro SQL and other procedures within it are the most useful right now. Additionally, it has a wide feature set and capabilities

Read full review

FA

Francisco Aparicio

Advisor at KPMG

Jun 17, 2021

The solution is user-friendly, the resource for the query builder is very useful, and the ability to explore the data is a benefit.

Read full review

GZ

Cenior Healthcare Economic Consultant at a healthcare company with 10,001+ employees

May 7, 2020

Areas where SAS EG does a better job than regular SAS are in the realm of importing and exporting data. For instance, exporting a SAS data set in Unix to an Excel spreadsheet on a PC is a simple task compared to doing the same task with Base SAS.

Read full review

Business analyst at BB seg

Dec 1, 2022

The query builder feature is the most valuable.

Read full review

MB

Monica Besleaga

SAS Application Architect at a computer software company

Apr 26, 2021

Filter and sort query builder is valuable. The ability to do advanced SAS programming is also a useful feature because we can do anything by using Enterprise Guide. It has a lot of functionalities. We can build ETL processes. There are clients who are using SAS Enterprise Guide to build ETL processes. They have a SAS-based program that is scheduled to run at a certain frequency to produce some reports for the business. It is a very useful tool for ETL unit tests and functional tests. You can also do data science projects in SAS Enterprise Guide by using different statistics. During my MBA, we used SAS Enterprise Guide for our statistic course. To query the data, there are many solutions such as SQL, but these tools are only a part of the integration. They are only useful for querying the data and require knowledge of SQL, so they are not suitable for business users. SAS Enterprise Guide can be very easily used by business users to filter and sort the data and build queries. It is not necessary to have coding skills to use SAS Enterprise Guide. For this reason, it is attractive for businesses.

Read full review

Show 10 more reviews (out of 24)

SAS Enterprise Guide Cons review quotes

reviewer2232579

Data Analyst at a financial services firm with 10,001+ employees

Jul 12, 2023

Recently, we realized that SAS Enterprise Guide is not so stable and gives us some outputs which are not suitable...Sometimes it's quite hard to report its stability issues.

Read full review

OL

Data Engineer at Ministry of Health New Zealand

Oct 19, 2022

Setting up SAS Enterprise Guide is somewhat messy and complex.

Read full review

JR

IT Administrator with 1-10 employees

Jun 15, 2022

I would like it to give more information rather than just a forever loop that forces you to shut down the system. Give you more error messages without stopping the entire project, or even the entire application. That it displays more error messages rather than terminating the application.

Read full review

SAS Enterprise Guide

Free Report: SAS Enterprise Guide Reviews and More

Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.

893,221 professionals have used our research since 2012.

reviewer1734420

Head of Customer Intelligence & Research at a financial services firm with 5,001-10,000 employees

May 4, 2022

It is expensive.

Read full review

Karunakar Kankata

Data Scientist at a tech services company with 1,001-5,000 employees

Oct 10, 2023

The technical support response time has been consistently slow, and this has been a concern.

Read full review

reviewer1640493

Senior Manager, Data Science and AI / ML Manager at a tech vendor with 10,001+ employees

Jun 23, 2022

We don't use SAS Enterprise Guide that much here because we haven't explored some of the statistical modeling capabilities. However, I do not think SAS Enterprise Guide provides all the machine learning features that we want. Those would be separate products from SAS, such as SAS Buyers or any of the other solutions, which will give us the capabilities that we are looking for.

Read full review

FA

Francisco Aparicio

Advisor at KPMG

Jun 17, 2021

There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL.

Read full review

GZ

Cenior Healthcare Economic Consultant at a healthcare company with 10,001+ employees

May 7, 2020

I had difficulty with the diagrammatic flow chart style representation of projects. When projects got too large and complex (which was basically every project, except the most trivial). There just wasn't enough real estate to display the flow chart and dependencies without a lot of scrolling, even when a flow was down to minimum tasks. My recourse was making the flow less "atomic". E.g., rather than use the various subset, etc., tasks as program nodes to display the details, I would write chunks of code that did a few things and use them as SAS program nodes.

Read full review

Business analyst at BB seg

Dec 1, 2022

The stability is not very reliable.

Read full review

MB

Monica Besleaga

SAS Application Architect at a computer software company

Apr 26, 2021

Our data warehouse is built on the Netezza database. We have SAS BI, and we populate the Netezza database. When we have tables with, for example, a hundred million rows in Netezza, SAS Enterprise Guide doesn't work. It doesn't return any results. It works for around 30 to 40 million rows, but it is not working for anything more than that. This issue is only with the Netezza database. With Oracle, it is quite good. They can improve its performance with the Netezza database. There should be one unique tool that includes SAS Data Integration Studio and SAS Enterprise Guide for more integration capabilities. With SAS Enterprise Guide, it is not possible to create connections and libraries and build transformations that can be used for other projects. This tool should have all capabilities that SAS Enterprise Guide does not have. Such a tool would be perfect because it will be used by developers and business users at the same time. In addition to the integration capabilities, they should also provide more deployment capabilities. There should be an option to easily create SAS packages and export them from one environment to another. There could also be a possibility to connect with R and Python. Open-source tools are hot in the market nowadays, and it would be good to extend its capabilities.

Read full review

Show 10 more reviews (out of 24)

Product Categories

Product Categories

Data Preparation Tools

Popular Comparisons

Popular Comparisons

Alteryx vs SAS Enterprise Guide

Unifi vs SAS Enterprise Guide

Toad Data Point vs SAS Enterprise Guide

ReportMiner vs SAS Enterprise Guide

Altair Monarch vs SAS Enterprise Guide

Alteryx Designer Cloud vs SAS Enterprise Guide

SAS Data Loader For Hadoop vs SAS Enterprise Guide

See all alternatives

Product Categories

Product Categories

Data Preparation Tools

Popular Comparisons

Popular Comparisons

Alteryx vs SAS Enterprise Guide

Unifi vs SAS Enterprise Guide

Toad Data Point vs SAS Enterprise Guide

ReportMiner vs SAS Enterprise Guide

Altair Monarch vs SAS Enterprise Guide

Alteryx Designer Cloud vs SAS Enterprise Guide

SAS Data Loader For Hadoop vs SAS Enterprise Guide

See all alternatives

Related questions

21

When evaluating Data Preparation Tools, what aspect do you think is the most important to look for?

28

Why is Data Preparation Tools important for companies?