We use SAS Enterprise Guide for ETL and data processing.
Senior Manager, Data Science and AI / ML Manager at a tech vendor with 10,001+ employees
Wide feature set, highly stable, but lacking features
Pros and Cons
- "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 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."
What is our primary use case?
How has it helped my organization?
My team is not using SAS Enterprise Guide extensively, but I imagine it's being used heavily for processing a lot of workloads in my company which has been an improvement.
What is most valuable?
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
What needs improvement?
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.
Buyer's Guide
SAS Enterprise Guide
October 2024
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
For how long have I used the solution?
I have been using SAS Enterprise Guide for approximately 10 years.
What do I think about the stability of the solution?
SAS Enterprise Guide's stability is fantastic.
What do I think about the scalability of the solution?
The scalability of the SAS Enterprise Guide is good.
We have several hundred users using this solution in my organization. We have data analysts, data scientists, developers, and other roles using it.
We do not have plans to increase usage because we only use the solution for a particular purpose.
How are customer service and support?
I have not contacted the support from SAS Enterprise Guide.
What was our ROI?
We have seen a return on investment from using SAS Enterprise Guide.
What other advice do I have?
SAS Enterprise Guide does what it does quite well, we use it for a particular purpose. We haven't explored some of the other opportunities with a lot of the statistical modeling and other options that it provides, but those would be nice to have.
I would advise others to start with small use cases and then scale up. It will scale very well to many of the functions that you want in data science and data engineering.
I rate SAS Enterprise Guide a seven out of ten.
The reason I wouldn't rate Enterprise Guide as 10 is that it is lacking some features that we are looking for.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Scientist at a tech services company with 1,001-5,000 employees
A predictive data analytics that lacks support for advanced modeling techniques
Pros and Cons
- "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."
- "The technical support response time has been consistently slow, and this has been a concern."
What is our primary use case?
We use it as a comprehensive data analytics and modeling process within the banking sector. 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.
What is most valuable?
The aspects that are the most crucial are data engineering and predictive analytics tools.
What needs improvement?
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.
For how long have I used the solution?
I have been working with it for two years.
What do I think about the stability of the solution?
Over the past three months, we've been encountering a persistent problem where our sessions are inexplicably closing. This issue is especially troublesome when certain tasks run for extended periods, exceeding one hour or even five hours. The problem appears to be linked to session duration, which is limited to just sixty minutes.
What do I think about the scalability of the solution?
The scalability can be somewhat challenging.
How are customer service and support?
The technical support response time has been consistently slow, and this has been a concern. As vendors for the banking sector, we are responsible for maintaining all the servers, which means extended downtimes are more frequent. When we encounter critical issues, it takes quite some time for the support team to respond, causing additional challenges.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
We use Python as part of our scheduled tasks, especially for handling big data. In open-source settings, there's a more extensive and active community that helps address discrepancies, code errors, and other issues. When you encounter problems and search on Google in open-source contexts, you often find numerous examples and solutions to common errors, which is immensely helpful compared to our current situation with SAS.
How was the initial setup?
The initial setup process was not overly complex.
What's my experience with pricing, setup cost, and licensing?
The pricing and associated costs are substantial.
What other advice do I have?
Overall, I would rate it six out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
SAS Enterprise Guide
October 2024
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
Sr Manager - Reporting, Analytics and Quality Control (Business Transformation) at Golden 1 Credit Union
An easy-to-use interface for working with large datasets
Pros and Cons
- "This solution allows for simplified working with large datasets."
- "I would like to see better Charting in this solution."
What is our primary use case?
We use this solution for data manipulation and statistics.
How has it helped my organization?
This solution allows for simplified working with large datasets.
What is most valuable?
The visual interface makes teaching new analysts how to use the tool easy.
What needs improvement?
I would like to see better Charting in this solution.
For how long have I used the solution?
I have been using this solution for eight years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Head Of Analytics at a comms service provider with 1,001-5,000 employees
Easy-to-use with a drag-and-drop querying feature, this fine tool still lags in visualization and machine learning
Pros and Cons
- "The product has a drag-and-drop feature that is excellent for business users and that makes it easy-to-use."
- "The product is missing a visualization component so we have to use a separate tool for visualization."
- "Machine learning is not utilized and that could enhance the product."
What is our primary use case?
We primarily use the product for data analysis and investigations.
What is most valuable?
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.
What needs improvement?
I think machine learning should be added to the product. It already has virtually everything from the data wrangling perspective. Machine learning concepts could further enhance the user experience and the results.
The concept of visualization could also be added because, currently, we need to use a separate tool. We use Business Objects for data visualizations.
Competing products — like in case of Alteryx that is just in trial versions for now — has both machine learning concepts as well as some of the visualization capabilities within the data profiling features. SAS Guide will have to have these features to keep up with competing products and their capabilities.
If these elements do pan out properly in Alteryx, I may like it better than SAS Enterprise Guide overall. I have a data science background but the more advanced data science features are new in these products and they are very useful in analytics.
So SAS should work on ML (Machine Learning) features, visualizations, and even more on ease-of-use. It is good but everything can get better.
For how long have I used the solution?
I have been working with SAS Enterprise Guide for six years.
What do I think about the stability of the solution?
We have not yet had any stability issues with the product. First of all, it is working well. Secondly, on the hardware side, we thought that we need to have more resources, so we did a capacity planning exercise involving SAS. They gave us some recommendations to improve our environment moving forward. We are installing a new setup on new hardware based on those recommendations. This should maintain our current level of stability and maybe enhance performance.
I feel that SAS has a good foundation. It has not given us a lot of problems when it comes to performance. We were being proactive. It works really well in combination with Teradata, but there is a lot of room for performance optimization with both tools.
Using both platforms — and by that I mean featuring both SAS and Teradata — we do get our data out. In telco, the data volumes are huge, but even though that is the case we do not usually get stuck or experience stability issues.
There are a lot of ways to get the performance optimization you need from products, get the work done, and delegate your time. It takes evaluation and revisions to accomplish those goals.
What do I think about the scalability of the solution?
There are many more business users in our organization, but there are only about seven people who really use Enterprise Guide as technical people. We do not see much of a problem with scalability for either group of users.
How are customer service and technical support?
Technical support is good. Whenever we have a problem, we have technical support sessions. It can be improved, I believe, but I would say that it is not bad either. It works for us.
Which solution did I use previously and why did I switch?
We do use other tools on occasion although we are presently focused on Enterprise Guide as our core in analytics. Ultimately the goal is to get the best results in the easiest way. If that requires changing tools, that may be necessary. Right now we are using SAS along with Teradata.
How was the initial setup?
The initial setup is a bit complex. For the guest access setup, that is something that we do ourselves. But when it comes to the server installation, that is where we require support from SAS. When it comes to the server installation, the configuration is usually done by SAS themselves. The setup is something that is certainly too complex for business users or people who do not have a technical background. It is usually good to involve SAS even if you are going to an upgrade. It can just make things go more smoothly and keep from wasting time with unnecessary issues.
We just have one guy for the maintenance of the system. If there is a problem, then he can rely on support. There is only one guy because the product is pretty stable.
What other advice do I have?
When looking at different tools on the market for data analysis what you need depends on what you want to do. If you have a portfolio within your organization, you may feel that you will need a lot of other tools in addition to make a proper analysis. SAS is a broader solution. It is not just the Enterprise Guide. It has marketing automation and there is even stream processing. Then there is Enterprise Miner. Enterprise Guide is a suite and not just a one-dimensional tool.
If you feel that you are ready to make an investment and you need the capability of advanced analytics within your organization, you will be able to utilize the whole tech stack with Enterprise Guide. If that is the case, then obviously I think you should go for SAS because it is a more mature and evolved product than most other products. In addition, the opportunities for integration with the SAS platform is really good.
If you need a specialty architecture, you have Alteryx on one side and you have SAS on the other side. If you do go with Alteryx, then you have a separate campaign management tool and you may not be able to get the full benefit of an integrated solution.
People considering SAS Enterprise Guide should also look at Alteryx. It is pretty simple. Some people on my team feel that Alteryx is actually much easier to use for what they do and that its interface is much better even if it is similar to Enterprise Guide. The overall availability of different kinds of features is much better in Alteryx.
I think the first step of evaluating potential solutions should be to look at your roadmap. If you want to go start simple, then obviously you can start with any tool. But if you have a roadmap in place or if you are not a beginner, then I would suggest going for one integrated platform as a suite rather than multiple tools. Having an integrated solution is probably a better overall.
On a scale from one to ten where one is the worst and ten is the best, I would rate Enterprise Guide as a seven overall. It is a good product but it lacks some important features other products are coming out with.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Vice President, Enterprise Data Management, Analytics CoE at a financial services firm with 10,001+ employees
Its user interface and code builder are valuable features of the product
Pros and Cons
- "Enabled us to remove PC SAS, which reduced risk."
- "Takes advantage of our Enterprise SAS Grid."
- "More bi-directional integration with the SAS Studio suite of tools is needed."
What is our primary use case?
Using with SAS Grid, data manipulation, preparation, and modeling development.
How has it helped my organization?
- Enabled us to remove PC SAS, which reduced risk.
- Takes advantage of our Enterprise SAS Grid.
What is most valuable?
- The Copy task feature
- Portability with SAS Studio
- User interface and code builder
What needs improvement?
More bi-directional integration with the SAS Studio suite of tools is needed.
For how long have I used the solution?
More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Statistician
It Is a Reliable Program That Consistently Performs Well When It Comes to Manipulating Large Datasets
What is our primary use case?
We use SAS EG to manipulate large datasets and prepare them for actuarial analysis with other programs, as well as ad hoc analysis.
How has it helped my organization?
SAS EG is a reliable program that consistently performs well when it comes to manipulating large datasets. Furthermore, the process flow and code wizards help keep things well organized so that it's easy to pass on projects to other analysts.
What is most valuable?
As discussed above, the process flow and code wizards are very valuable as they allow any analyst, even those totally new to SAS, to quickly learn about new projects and get up to speed so that they can start working with it as fast as possible. The base SAS functionality of SAS EG delivers when it comes to consistently handling large datasets and, for the most part, it's not too difficult to write custom code to do whatever you want to do with your data. If things are ever too much, SAS's technical support team is easy to contact and incredibly helpful with any problem.
What needs improvement?
I realize that this is fairly impractical as a request, given how SAS EG is programmed, but I'd love it to be as quick as base SAS for simpler data queries. The intention of SAS EG is that the SAS commands are executed on a server, so this isn't a very fair comment to make. I do find the online documentation can, at times, be a little difficult to read through and understand and sometimes there aren't a lot of examples to help you understand. I'd love for there to be more examples as well as a summary post of some sort on how to go about interpreting the nuances of how the documentation is written.
For how long have I used the solution?
Less than one year.
How is customer service and technical support?
SAS has absolutely excellent technical support. I've reached out on multiple occasions for various issues, usually involving how to code something or an error with my code, and always gotten a response back within 24 hours. The technical support staff has always worked with me to ensure that they solve my issue and are very good at what they do; I've never been disappointed, even when asking about an issue with Windows that I was trying to circumvent by going beyond SAS's intended functionality.
What's my experience with pricing, setup cost, and licensing?
SAS has excellent customer service and their products are well tested and perform their intended function, however, they aren't inexpensive. Generally speaking, there is a higher initial cost to obtain a license and then a reduced renewal cost, but you'll be paying the renewal cost for as long as you want to keep using their software programs. SAS is careful to keep pricing a private matter, so it's hard to know if you're paying more or less than other clients for a license. It's also difficult to shop around and price compare as you need to enter into a discussion with a SAS representative to obtain a quote, personalized to you.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
SAS Application Architect at a computer software company
Easy to extend, stable, has a lot of functionalities, and doesn't require coding skills
Pros and Cons
- "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."
- "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."
What is our primary use case?
I am currently using this solution for testing purposes. I am working for a pharmaceutical company in Belgium, and we are building a data warehouse by using SAS Data Integration Studio, and we are using SAS Enterprise Guide to test our development. We are building Enterprise Guide projects by using query builder, filters, and other things. We have also built stored procedures. Sometimes, we also write SAS base code to perform unit tests after development and to do some sanity checks to respond to UAT questions. Overall, we are using the majority of functionalities of SAS Enterprise Guide.
How has it helped my organization?
A client has used SAS Enterprise Guide to build an ETL process that involves extracting and transforming the data and producing reports. These reports are very crucial and useful for their monthly and daily activities. By using SAS Enterprise Guide, they are able to deal with end-to-end processes for their business.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using this solution since 2005. It has been almost 16 years.
What do I think about the stability of the solution?
It is very stable.
What do I think about the scalability of the solution?
It is easy to extend for fast data integration functionalities. We have around 1,000 users. They are developers, business analysts, and project managers.
In terms of usage, my clients don't have any plans to expand its usage.
How are customer service and technical support?
They are responsive and very good. They respond within a day of creating a ticket.
How was the initial setup?
It is not quite easy to deploy. When we worked on the SAS migration project, the migration to Enterprise Guide was quite difficult. The deployment duration depends on the project. Generally, it would take a few days to solve all the issues.
What about the implementation team?
For the SAS migration project, we worked with the SAS Belgium team. With their help, it was okay, but it should be easier.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
I would recommend this solution. It is a very good tool for outputs from different domains, such as ETL reporting, data science, etc. It would be good to bring more functionalities similar to Data Integration Studio so that we have one single tool.
I would rate SAS Enterprise Guide an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Finance System & Process Senior Manager at a financial services firm with 1,001-5,000 employees
Saved us in manpower; no longer necessary to have a dedicated data team
Pros and Cons
- "The Query Builder is very valuable."
- "For some of the advanced functions, you need to learn some SAS code to get what you want."
What is our primary use case?
Our primary use case is to analyze the sales data of our company. We have an in-house database that has all data relating to our agents and our production. I use it when I want to have a quick check on the data. I'm the finance system and process senior manager in the company.
How has it helped my organization?
I think that this solution is a good start to get into the data analysis field. The license for this is not per user so anyone who wants to use the product can approach it, and can take a look at it, rather than it involving a lengthy process. If the solution was per user, we would need to take into consideration whether it was necessary for a particular user to access it. I think that's how it changed our business. Previously we had a dedicated data team, so every request needed to be sent via them. Now the solution is open to everyone in the company so they can get on board with all the data analysis.
What is most valuable?
I think the Query Builder is very valuable. You just need to track and drop, everything is on the interface, without the need of too much coding.
What needs improvement?
For improvement, I think the user interface is too complicated. For some of the advanced functions, you need to learn some SAS code in order to get what you want. I'm ideally looking for is something that is purely code free and user friendly, which doesn't require any kind of programming.
For additional features I really want something that can make it easier for me to schedule the programs. I do know that SAS now has a solution to schedule the program, but if it could be something built-in within the SAS Enterprise Guide, that would be great.
For how long have I used the solution?
I've been using this solution for about three years.
What do I think about the stability of the solution?
I think it is quite stable. In some circumstances, such as suddenly losing internet connection, it might return an error and you need to restart the whole program in order to make it work.
Sometimes some data can be lot but overall I think that the stability is good.
What do I think about the scalability of the solution?
Due to the subscription mechanism, everyone in the company can use it so it's very good in terms of scalability.
How are customer service and technical support?
I haven't needed to contact technical support because they have a very large online community for support and I can easily find the answers to what I need just by using Google.
How was the initial setup?
I think initial setup is quite straightforward but if you compare it to say, Access, then it's more complicated to use than other, more traditional tools.
What other advice do I have?
Anyone implementing this solution should check the online manual where they have very good information on how best to use the product. Whenever you have a problem that needs to use a data solution, you can just do a quick Google, and add in the link to that website, and it can show you a lot of solutions. There are also free education manuals and training courses from SAS itself. It's worth taking a look at the SAS programming essential one, and get used to this product.
Always save your data!
I would rate this product an eight out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free SAS Enterprise Guide Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Product Categories
Data Preparation ToolsPopular Comparisons
Toad Data Point
Altair Monarch
Trifacta Wrangler Enterprise
Buyer's Guide
Download our free SAS Enterprise Guide Report and get advice and tips from experienced pros
sharing their opinions.