Likelihood to Recommend When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.
Read full review SAS Enterprise Guide is good at taking various datasets and giving analyst/user ability to do some transformations without substantial amounts of code. Once the data is inside SAS, the memory of it is very efficient. Using SAS for data analysis can be helpful. It will give good statistics for you, and it has a robust set of functions that aid analysis.
Read full review Pros SAS/Access is great for manipulating large and complex databases. SAS/Access makes it easy to format reports and graphics from your data. Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs. Read full review I think the most useful aspect of SAS Enterprise Guide is the ability to use a point-and-click interface to create graphics, transform data, and perform statistics. The best part is that SAS Enterprise Guide creates base SAS code from the process, making it easy to reproduce analyses. SAS Enterprise Guide makes creating summary statistics about as easy as it gets. If one doesn't know proc means or proc tabulate, one can use SAS Enterprise Guide instead. The time-series forecasting procedures within SAS Enterprise Guide produce fairly good results. SAS Enterprise Guide makes time-series model comparisons relatively straight-forward. Read full review Cons Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres. Debugging errors from the logs is a complicated process. E-mail alert system is very primitive and needs customization to make it more modern, Cannot send SMS alerts for jobs. Read full review SAS Studio has some great examples that can be implemented. Adding a filter to the output datasets for one. Some issues around having to enter my password every time I open it up. Some people are having this issue and others aren't. SAS admin is at a loss to work out why it's occurring. Read full review Likelihood to Renew We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.
Read full review On account of current user experience and the organization-wide acceptance.
Read full review Usability The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.
Read full review It's not all bad, but I don't believe that an enterprise purchase of SAS is worth the expense considering the widely available set of tools in the data analytics space at the moment. In my company, it's a good tool because others use it. Otherwise, I wouldn't purchase a new set of it because it doesn't have some of the better analytical functions in it.
Read full review Performance It worked as expected.
Read full review Support Rating With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.
Read full review I did not use the technical support of SAS EG. I can say that I have had hard time to find online tutorials or projects for SAS EG. For instance, it is hard to find completed researches or designed algorithms used with SAS EG. Sometimes it just depends on user's skill set and experience with databases and programming.
Read full review Implementation Rating I've not worked hands-on with the implementation team, but there were no escalations barring a few hiccups in the deployment due to change in requirement & adoption to our company's remote servers.
Read full review Alternatives Considered Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.
Read full review Why I prefer SAS EG: Data processing speed is much faster than that R Studio. It can load any amount of data and any type of data like structured or unstructured or semi-structured. Its output delivery system by which we have the output in PDF file makes it very comfortable to use and share that file to clients very easily. Inbuilt functions are very powerful and plentiful. Facility of writing macros makes it far away from its competitors.
Read full review Return on Investment We have more users who can connect to the many different data sources. Our users do have existing SAS programming knowledge and that can carry over. Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction. Read full review Positive (cost): SAS made a bundle that include unlimited usage of SAS/Enterprise Guide with a server solution. That by itself made the company save a lot of money by not having to pay individual licences anymore. Positive (insight): Data analysts in business units often need to crunch data and they don't have access to ETL tools to do it. Having access to SAS/EG gives them that power. Positive (time to market): Having the users develop components with SAS/EG allows for easier integration in a production environment (SAS batch job) as no code rework is required. Read full review ScreenShots