Coming October 25: PeerSpot Awards will be announced! Learn more

SAS Enterprise Guide Pros

Monica Besleaga - PeerSpot reviewer
SAS Application Architect at a computer software company
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.
View full review »
JR
IT Administrator with 1-10 employees
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.
View full review »
OQ
Head of Customer Intelligence & Research at a financial services firm with 5,001-10,000 employees
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.
View full review »
Buyer's Guide
SAS Enterprise Guide
September 2022
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
635,987 professionals have used our research since 2012.
Karima TOUATI - PeerSpot reviewer
Actuarial Analyst at a insurance company with 501-1,000 employees
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.
View full review »
VD
Senior Manager, Data Science and AI / ML Manager at a tech vendor with 10,001+ employees
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
View full review »
Francisco Aparicio - PeerSpot reviewer
Advisor at KPMG
The solution is user-friendly, the resource for the query builder is very useful, and the ability to explore the data is a benefit.
View full review »

SAS Enterprise Guide Cons

Monica Besleaga - PeerSpot reviewer
SAS Application Architect at a computer software company
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.
View full review »
JR
IT Administrator with 1-10 employees
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.
View full review »
OQ
Head of Customer Intelligence & Research at a financial services firm with 5,001-10,000 employees
It is expensive.
View full review »
Buyer's Guide
SAS Enterprise Guide
September 2022
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
635,987 professionals have used our research since 2012.
Karima TOUATI - PeerSpot reviewer
Actuarial Analyst at a insurance company with 501-1,000 employees
They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything.
View full review »
VD
Senior Manager, Data Science and AI / ML Manager at a tech vendor with 10,001+ employees
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.
View full review »
Francisco Aparicio - PeerSpot reviewer
Advisor at KPMG
There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL.
View full review »
Buyer's Guide
SAS Enterprise Guide
September 2022
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
635,987 professionals have used our research since 2012.