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

"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."
"It has improved tremendously moving from providing an easy menu-driven system to also providing an excellent platform for developing and running full production systems, with minimal coding, which enabled increasing popularity among many non-programmers."
"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 query builder feature is the most valuable."
"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."
"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."
"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."
"This solution allows for simplified working with large datasets."
"We love it."
"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."
"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."
"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."
"I have never experienced any issues with customer service."
"The best thing about it is its automation features."
"One of the greatest features is that you can get data from anywhere to anywhere with Toad Data Point."
 

Cons

"A log belongs to each program. I have experienced a situation where when I run just the exec files, it replaces the whole log and I wanted to see the earlier log, then this was not possible."
"More bi-directional integration with the SAS Studio suite of tools is needed."
"It would be very useful if EG could be enhanced to automatically file and clear the project log to ensure non-stop running of the project."
"They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything."
"I feel that the performance could be increased by leveraging multi-thread with any SAS BI platform, not just the high performance ones."
"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."
"Machine learning is not utilized and that could enhance the product."
"For some of the advanced functions, you need to learn some SAS code to get what you want."
"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."
"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."
"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."
"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."
"It's not user-friendly. Once you start using it, you eventually get to know the features."
"It's not user-friendly. Once you start using it, you eventually get to know the features."
"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."
"The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version."
 

Pricing and Cost Advice

"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."
"It is very expensive. We have a basic license, and there are many features that are not available with the basic version."
"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."
"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."
"Management liked it a lot because the license per seat was cheaper than a traditional SAS environment."
"The price of Toad Data Point was approximately $500 annually."
"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."
report
Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
851,604 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
25%
Government
10%
Healthcare Company
10%
Computer Software Company
8%
Financial Services Firm
36%
Healthcare Company
12%
Government
8%
Manufacturing Company
5%
 

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.
851,604 professionals have used our research since 2012.