"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."
"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."
"The solution is user-friendly, the resource for the query builder is very useful, and the ability to explore the data is a benefit."
"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."
"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"
"We are able to work on the server, and I can copy a data set and share it with someone in my team. Similarly, if I want some data from them, I can get it. Being able to work on the server and being able to switch from one user to another is a good thing. It is reliable and powerful, and its community is very wide."
"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."
"You can create a lot of ingestions based on the file levels or based on the time."
"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."
"They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything."
"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."
"Setting up SAS Enterprise Guide is somewhat messy and complex."
"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."
"It is expensive."
"There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL."
"The major pain point with Zaloni is that their exception handling is not good. If any event happens, it doesn't tell you at which point it failed and it doesn't tell the operations team how they should take corrective actions unless you call Zaloni and then identify the issues. That is one issue."
SAS Enterprise Guide is an intuitive statistical analysis solution that enables users of all backgrounds to engage in statistical analysis.
Users can create and deploy customized tasks and dynamic content that best meet their needs. Interactive content can easily be shared on the cloud and the internet.
Benefits of SAS Enterprise Guide
Some of the benefits of using SAS Enterprise Guide include:
Reviews from Real Users
SAS Enterprise Guide is a statistical analysis tool that stands out among its competitors for a number of reasons. Two major ones are the solution’s intuitive nature and the suite of functionalities that it offers. SAS Enterprise Guide makes it easy for users who lack a background in statistical analysis to create workflows. The solution enables users to customize and configure queries without requiring them to have a background in coding. SAS Enterprise Guide has a wide variety of functionalities. It is highly flexible and gives users the ability to complete many different tasks.
The head of analytics at a communications services provider writes, “I think that the ease of use is the most valuable feature. I know SQL. I even taught SQL. But new people who come to the tool without in-depth knowledge of SQL or people who do not have an analytics background can still use the tool. It is very easy for these new users to climb the learning curve using SAS Enterprise Guide because of the way it was created with ease-of-use in mind. It is well-oriented to the business user. In no time new users are able to create workflows. Obviously, it is best if they have some basic knowledge of how things work in doing analysis — like the concept of joins, data profiling, and maybe some other SQL-related concepts. But the key here is they do not need to know how it is coded or the exact commands. All the features are available within Enterprise Guide through a drag-and-drop interface so queries can be built without extensive knowledge of how that works behind the scenes. The ease-of-use makes the tool valuable even for someone who is near the beginner level.”
Monica B., an SAS Application Architect at a computer software company, writes, “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 statistics course.”
Zaloni simplifies big data for transformative business insights. We work with pioneering enterprises to modernize their data architecture and operationalize their data to accelerate insights for everyday business practices.
SAS Enterprise Guide is ranked 2nd in Data Preparation Tools with 7 reviews while Zaloni Data Platform is ranked 5th in Data Preparation Tools with 1 review. SAS Enterprise Guide is rated 7.8, while Zaloni Data Platform is rated 7.0. The top reviewer of SAS Enterprise Guide writes "Easy to extend, stable, has a lot of functionalities, and doesn't require coding skills". On the other hand, the top reviewer of Zaloni Data Platform writes "Solid multi-ingestion tool but with poor exception handling". SAS Enterprise Guide is most compared with Alteryx, Toad Data Point, Trifacta Wrangler Enterprise, SAS Data Loader For Hadoop and Altair Monarch, whereas Zaloni Data Platform is most compared with Collibra Governance, Alteryx and Alation Data Catalog.
See our list of best Data Preparation Tools vendors.
We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.