I like the ease of use. 

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. 

The application uses standard SQL in the background. You can go behind the scenes and use the information you want to change. 

I like the interface where you can get help if you need it. They also have functions that can be called up to perform various tasks. For example, If you want to write a case statement for something, just put that function in there and see what syntax you might be missing.

One of the features of the SAS Enterprise Guide is that it has a server, and we can access the server. It's easier for us to access the solution and comparatively faster than a desktop.

Enterprise Guide is much better at generating reports than many solutions. We often use it to generate reports, and people interpret them how they like. They often probably use Excel spreadsheets or something like that after they get our data.

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.

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.

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.

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

The aspects that are the most crucial are data engineering and predictive analytics tools. 

The query builder feature is the most valuable.

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.

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.

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

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.  

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.

• The Copy task feature
• Portability with SAS Studio
• User interface and code builder

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.

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.

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

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.

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

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.

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.

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.

Click and drop function.