SAS Enterprise Guide Valuable Features

Virtualization Manager at NMC Health

In Daman, I had used the data module, where you can join the table and take whatever data we require for our work. You join tables and create columns as you wish, then analyze data in various ways depending on what the problem is. We used it to detect fraud, abnormalities, anomalies, abnormal trends, etc. It's also good for exporting and importing tables.

View full review »
Head Of Analytics at a comms service provider with 1,001-5,000 employees

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.  

View full review »
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 »
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,773 professionals have used our research since 2012.
Finance System & Process Senior Manager at a financial services firm with 1,001-5,000 employees

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.

View full review »
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 »
Cenior Healthcare Economic Consultant at a healthcare company with 10,001+ employees

Areas where SAS EG does a better job than regular SAS are in the realm of importing and exporting data. For instance, exporting a SAS data set in Unix to an Excel spreadsheet on a PC is a simple task compared to doing the same task with Base SAS.

The usual virtues of drag and drop style interfaces with a flow chart-like depiction of the project and the ability to separate the project into individual flows, i.e., one for the slow data pulls from the databases, a second for data crunching, and a third for the outputting to the PC. The ability to copy the underlying SAS code from a node and modify it and/or reuse it elsewhere, and also the built-in versioning of program code stored in the project, is very useful for something that is run periodically and frequently updated.

The ability to include it as part of the project code housed on either the PC or the UNIX box is handy, although EG doesn't provide the ability to version the code.

View full review »
Data Architect at levvel

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).

View full review »
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.

I feel I use maybe a 10th of the potential of the solution. It has a lot of features for reporting and data, with a lot of exploration you can do. There are many research areas that give you logistical information about the data.

View full review »
Sr Manager - Reporting, Analytics and Quality Control (Business Transformation) at Golden 1 Credit Union

The visual interface makes teaching new analysts how to use the tool easy.

View full review »
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,773 professionals have used our research since 2012.