SAS Enterprise Guide Reviews

We use this solution for moving users that need statistical data analysis and data transformation functionality that do NOT have a background in programming and/or SQL to a tool that allows for some degree of self-service. It also provides access to data sources (databases that require administrative access) that do not support individual user access.

Users that want to code SAS but don't have expertise or comfort coding and/or running SAS in a Unix background will use this as a SAS IDE, and not as a true graphical process environment with the ability to "re-use" common process patterns. If the user base can be given some good basic guidelines it can be a serious productivity improvement tool.

Statistical functionality and basic database interaction can become very straightforward for business users that don't have a background in SQL and data analysis. It allows business customers not familiar/comfortable with Unix environments to continue to use SAS functionality with interaction to data sources that are outside of their immediate control (application databases on remote hosts).

I would like to see integration with schedulers when run from hosting environments such as Citrix. Currently, SAS Enterprise guide in  CITRIX hosted environment appears to have access to Windows task manager to schedule EGP's. However, as soon as the client logs out due to windows "roaming profiles" being dynamic the scheduler does not work! It does not fail just doesn't do anything.

In administered/remote client/server environments( such as CITRIX), the ability for users to catalog and save database metadata independent of administrators interaction and support would be helpful.  Currently the user must (with the help of an administrator ) access a database from SAS Console with a valid credential and retrieve the database metadata (limited to what the user has access to via credential). If each user has potentially different access rights based on ID/password at the database an administrator with greater privileges must login to the database and catalog the metadata to cover ALL of the database metadata potentially used by any single user/group and then make it available to all groups. 

We have been using this solution for three and a half years.

I use it for programming. When we import data sets or databases, we work with data management and program scripts, etc. We have its basic license.

We work with large data sets that cannot be handled in Excel. SAS gives us the opportunity and the privilege to work with large data sets. It is very easy with SAS, and it saves time. For example, if I want to use the same data with Excel, it would take a whole day, but with SAS, I can do it in two or three hours at the most.

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.

They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything.

I have been working with this solution for two years. I use it daily for my work.

It is reliable.

It is scalable. It can handle large data sets. There is no problem with that.

Currently, we have a team of five people. I have a manager and other colleagues. All of us don't have the same role. We all handle data, but we have different diplomas. I work as an actuarial analyst, statistics engineer, and data analyst.

I am not sure if we have a contact for technical support from them, but there is a big community of SAS.

We used the open-source product R, which is not exactly similar. We switched because it was a part of our strategy to use SAS. In terms of time response, R is not very powerful. SAS is more powerful in terms of data management., and someone who is not very experienced with programming can use the UI.

I was not involved in the initial setup. Its maintenance and administration are handled by IT, but they're not very well-trained in this solution. It is a new one for them, and sometimes, we do get stuck because they are not very experienced with this solution and its features.

It is very expensive. We have a basic license, and there are many features that are not available with the basic version.

You must have a basic background in programming, such as SQL programming, to use it easily.

I would rate SAS Enterprise Guide an eight out of ten.

Everyday use for application development (reporting, data analysis, scoring, and ETL). 

SAS EG really helped us fix a security problem with SAS PC by bringing the data on a secure SAS server. Then, we could have the end users use SAS EG for work with SAS. This secured the overall solution, also bringing better performance by having people work on a powerful server instead of a workstation.

Some of the tasks provided are really useful, such as "characterize data". This feature saved me a lot of time in the past years by providing me with a complete picture of a data table with just a few clicks. It is great for profiling data.

I feel that the performance could be increased by leveraging multi-thread with any SAS BI platform, not just the high performance ones.

I see no reason for limiting the process to sequential all the time.

People used to work with SAS PC a lot where I used to work. This was causing security issues with data residing on physical PCs.

I use it for quality assurance and identification of outliers. EG is great for a quick standardized sort of analysis.

It has definitely improved our communication with senior management.

The point and click makes it easy to transfer the knowledge to new employees. It is also compatible with other softwares, such as Excel. 

Sentiment analytics would be a great feature to add into EG, as well as compatibility with machine learning languages, such as Python and R. 

It is the solution that we have been using since before I started working at my organization.

SAS EG is an excellent tool for data manipulation and analysis.

SAS EG has evolved significantly, especially in the past 10 years. 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. As result of this, the application overall helped greatly improve the efficiency of the organization.

SAS EG offers many excellent features, such as parallel execution on the same server, controlling output datasets in the process flow, and conditional processing. Just to name a few.

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.

I have been using SAS for over 20 years and EG since its inception. I am happy with its power to manipulate data in a flexible, efficient way.

SAS/EG is a very good tool for data management and analytics tasks. You can use the workflow to create jobs in a guided mode or you can write code in SAS/BASE. The workflow possibility is a very good option, because you don't need to know programming to create analytics projects.

This tool has improved the work in customer intelligence or business intelligence departments.

I found difficulties when trying to connect to Big Data environments, such as Apache Spark.

For 10 years using SAS/EG and SAS/BASE.

No.

No.

An eight out of 10.

I have also used R. Both are good tools.

The initial setup was not complex. It took only two days.

I think the price is high. Now you have alternatives, open source to do analytics projects, and the licensing of SAS/EG is expensive.

I have also used R. Both are good tools.

If you have enough budget, it is a very good tool. It's important to take into account that if you need to work with advanced models like neural networks or random forest that models are not supported by SAS/EG, you will need another SAS tool, such as SAS Enterprise Miner.

We make the most use of scheduled processing with Base SAS. If there is an error in one process, the others do not run as well because of possibly one error. Therefore, we now mostly use the Enterprise Guide for such scheduling purposes, so error processes will not inhibit the others.

SAS EG improved my organization. We do not bother any longer with some programs did not run, hence having to rerun them again. 

Scheduling downtime of some programs has been eliminated. The process flows are a very exciting feature to use. Also, for the tasks, this makes it easier to just filter without having to really code.

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.

• Data preparation
• Statistics.

Efficiency.

Click and drop function.

Licensing.