Try our new research platform with insights from 80,000+ expert users

SAS Enterprise Guide vs Toad Data Point comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 10, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAS Enterprise Guide
Ranking in Data Preparation Tools
2nd
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
24
Ranking in other categories
No ranking in other categories
Toad Data Point
Ranking in Data Preparation Tools
5th
Average Rating
9.0
Reviews Sentiment
7.6
Number of Reviews
5
Ranking in other categories
Data Integration (29th)
 

Mindshare comparison

As of May 2025, in the Data Preparation Tools category, the mindshare of SAS Enterprise Guide is 17.9%, down from 26.2% compared to the previous year. The mindshare of Toad Data Point is 8.0%, up from 7.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Preparation Tools
 

Featured Reviews

Karunakar Kankata - PeerSpot reviewer
A predictive data analytics that lacks support for advanced modeling techniques
I find it challenging when I need to use certain functions and predictive modeling techniques in SAS. The procedures and data steps for database analysis take longer, and I've noticed that the current version we are using, lacks support for advanced modeling techniques. We've requested support for these advanced algorithms, but it seems there have been challenges in implementing them. As a result, we are facing difficulties in developing advanced models. Another issue we've encountered is that the community support for SAS is relatively limited compared to open-source environments.
Aaron Payne - PeerSpot reviewer
Offers power developers the tooling they need
I am not the end user of this solution. I am not close enough to it because I manage the platform that it runs against. The end users who use the Toad tool come against the database that my team manages, so it is hard for me to provide any area for improvement when it comes to the Toad tool. However, in the administration case, cost is a significant issue. The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version. Scalability is difficult when it is that costly.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"Statistical functionality and basic database interaction can become very straightforward for business users that don't have a background in SQL and data analysis."
"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."
"We do not bother any longer with some programs did not run, hence having to rerun them again."
"The product has a drag-and-drop feature that is excellent for business users and that makes it easy-to-use."
"It is also compatible with other softwares, such as Excel."
"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."
"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."
"We love it."
"One of the greatest features is that you can get data from anywhere to anywhere with Toad Data Point."
"With Toad Data Point, I can automate most steps automatically."
"The Connectivity and Connection Manager supports a broad number of connection types, and it is trivial for end-users to set up their own connections to sources."
"The best thing about it is its automation features."
"I have never experienced any issues with customer service."
"The most valuable features of Toad Data are you could write a parameterized query and it wouldn't error out, it would give you the parameters that you could input. The auto-formatting feature is useful because it was great for keeping your queries neat and understandable. The auto comment, and uncomment toggles that you could do were convenient."
"It provides better SQL development tooling than SQL Developer, which is not a sufficient tool for all development use cases. It offers power developers the tools they need."
 

Cons

"There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL."
"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."
"I would like to see integration with schedulers when run from hosting environments such as Citrix."
"The stability is not very reliable."
"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."
"Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user friendly and easier to use. Tableau is very easy to use. It's just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau."
"It is expensive."
"Setting up SAS Enterprise Guide is somewhat messy and complex."
"It's not user-friendly. Once you start using it, you eventually get to know the features."
"I used their report writing a little bit, however, it could improve since it's not a really good report writer and it's a little clunky."
"I used their report writing a little bit, however, it could improve since it's not a really good report writer and it's a little clunky."
"On the scheduling server, some scheduled reports just sit there and never execute for the first time. After manually executing the first time, they run with no issues."
"The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version. Scalability is difficult when it is that costly."
"It's not user-friendly. Once you start using it, you eventually get to know the features."
"The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version."
"Toad Data could improve by having additional features, such as query prediction. This could help someone who's not the strongest programmer. If the software could help them write queries correctly it would be very helpful, especially for small development teams or teams that lack the input skills necessary to write and program efficiently."
 

Pricing and Cost Advice

"Management liked it a lot because the license per seat was cheaper than a traditional SAS environment."
"I did look at the prices a few years ago, and I believe it was approximately $1,000 for a yearly subscription at that time."
"It is expensive. We get a different price based on our corporate rate. So, I'm not sure what the general cost is because we got a special rate for it."
"It is very expensive. We have a basic license, and there are many features that are not available with the basic version."
"The pricing and associated costs are substantial."
"In general, SAS has high prices, which is a reason why some clients don't use SAS solutions. The licensing is on a yearly basis."
"The Mac licenses are expensive, costing 1,600 dollars each. This is much higher than for the Windows version. I maintain a very limited number of licenses due to this cost."
"The cost of this product is reasonable."
"The price of Toad Data Point was approximately $500 annually."
report
Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
849,686 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
25%
Healthcare Company
10%
Government
10%
Insurance Company
8%
Financial Services Firm
36%
Healthcare Company
13%
Government
7%
Manufacturing Company
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about SAS Enterprise Guide?
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 man...
What needs improvement with SAS Enterprise Guide?
I find it challenging when I need to use certain functions and predictive modeling techniques in SAS. The procedures and data steps for database analysis take longer, and I've noticed that the curr...
What is your experience regarding pricing and costs for Toad Data Point?
The pricing for Toad Data Point is where it gets into trouble. Microsoft is free, so if you get SQL Server, you get all the other stuff with it. You have to use several Microsoft tools that don't a...
What needs improvement with Toad Data Point?
I used their report writing a little bit, however, it could improve since it's not a really good report writer and it's a little clunky.
What is your primary use case for Toad Data Point?
When I use it, I'm using it for writing SQL or testing SQL code. I used to use it for moving data, loading files into database tables, from tables to other tables.
 

Overview

 

Sample Customers

Canary Islands Statistics Institute
Concordia University
Find out what your peers are saying about SAS Enterprise Guide vs. Toad Data Point and other solutions. Updated: April 2025.
849,686 professionals have used our research since 2012.