IT Central Station is now PeerSpot: Here's why

SAS Enterprise Guide OverviewUNIXBusinessApplication

SAS Enterprise Guide is #2 ranked solution in top Data Preparation Tools. PeerSpot users give SAS Enterprise Guide an average rating of 8 out of 10. SAS Enterprise Guide is most commonly compared to Alteryx: SAS Enterprise Guide vs Alteryx. SAS Enterprise Guide is popular among the large enterprise segment, accounting for 75% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 23% of all views.
SAS Enterprise Guide Buyer's Guide

Download the SAS Enterprise Guide Buyer's Guide including reviews and more. Updated: June 2022

What is SAS Enterprise Guide?

SAS Enterprise Guide is an intuitive statistical analysis solution that enables users of all backgrounds to engage in statistical analysis.

Users can create and deploy customized tasks and dynamic content that best meet their needs. Interactive content can easily be shared on the cloud and the internet.

Benefits of SAS Enterprise Guide

Some of the benefits of using SAS Enterprise Guide include:

  • Provides users with robust, centralized, and role based system security. SAS Enterprise Guide enables users to protect their network from a wide variety of threats. A single system of security provides and authenticates system access credentials. Individuals are empowered to easily adjust their organization’s security credentials to meet their changing security needs.
  • Easily access and manipulate system data. SAS Enterprise Guide employs a user-friendly user interface that enables users to view and and use data without requiring them to have an extensive knowledge of coding. Business analysts can generate and disseminate reports without help. Information technology teams are freed up to handle more pressing issues. Datasets can also be embedded into the system so that users dont have to re-enter them into the system.

Reviews from Real Users

SAS Enterprise Guide is a statistical analysis tool that stands out among its competitors for a number of reasons. Two major ones are the solution’s intuitive nature and the suite of functionalities that it offers. SAS Enterprise Guide makes it easy for users who lack a background in statistical analysis to create workflows. The solution enables users to customize and configure queries without requiring them to have a background in coding. SAS Enterprise Guide has a wide variety of functionalities. It is highly flexible and gives users the ability to complete many different tasks.

The head of analytics at a communications services provider writes, “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.”

Monica B., an SAS Application Architect at a computer software company, writes, “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 statistics course.”

SAS Enterprise Guide Customers

Canary Islands Statistics Institute

SAS Enterprise Guide Video

Archived SAS Enterprise Guide Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Gerald Zuckier - PeerSpot reviewer
Cenior Healthcare Economic Consultant at a healthcare company with 10,001+ employees
Real User
Exporting a data set in Unix to an Excel spreadsheet on a PC is a simple task. Not enough real estate to display the flow chart and dependencies without a lot of scrolling.
Pros and Cons
  • "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."
  • "I had difficulty with the diagrammatic flow chart style representation of projects. When projects got too large and complex (which was basically every project, except the most trivial). There just wasn't enough real estate to display the flow chart and dependencies without a lot of scrolling, even when a flow was down to minimum tasks. My recourse was making the flow less "atomic". E.g., rather than use the various subset, etc., tasks as program nodes to display the details, I would write chunks of code that did a few things and use them as SAS program nodes."

What is our primary use case?

Mostly accessing medical claims data from mainframe warehouses, plus occasional spreadsheets, etc. Aggregating and scoring according to specified algorithms and identifying medical practitioners who are statistical outliers with respect to certain procedures. Loading results of these analyses into Microsoft SQL Server and writing queries for access by users without SAS licenses. Running SAS EG on a networked Windows PC, connected to a SAS Grid on a Unix network, accessing data warehouses in Teradata.

How has it helped my organization?

In general, for large complex programs, I found myself wishing I had access to the base SAS environment. People did not use the EG specific features, just writing long programs in Base SAS, using EG to launch them.  Also, I could never get the ability to run code in parallel on the SAS Grid. For instance, long running data pulls from multiple databases, when working, were slow when running the entire program sequentially in Base SAS.

What is most valuable?

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.

What needs improvement?

I had difficulty with the diagrammatic flow chart style representation of projects. When projects got too large and complex (which was basically every project, except the most trivial). There just wasn't enough real estate to display the flow chart and dependencies without a lot of scrolling, even when a flow was down to minimum tasks. My recourse was making the flow less "atomic". E.g., rather than use the various subset, etc., tasks as program nodes to display the details, I would write chunks of code that did a few things and use them as SAS program nodes.
Buyer's Guide
SAS Enterprise Guide
June 2022
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
608,010 professionals have used our research since 2012.

For how long have I used the solution?

Three years.

What's my experience with pricing, setup cost, and licensing?

Management liked it a lot because the license per seat was cheaper than a traditional SAS environment.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Finance System & Process Senior Manager at a financial services firm with 1,001-5,000 employees
Real User
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
SAS Enterprise Guide
June 2022
Learn what your peers think about SAS Enterprise Guide. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
608,010 professionals have used our research since 2012.
Data Architect at a tech services company with 201-500 employees
Real User
Top 10
Statistical functionality for non-technical users, but needs integration with scheduling tools
Pros and Cons
  • "Statistical functionality and basic database interaction can become very straightforward for business users that don't have a background in SQL and data analysis."
  • "I would like to see integration with schedulers when run from hosting environments such as Citrix."

What is our primary use case?

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.

How has it helped my organization?

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.

What is most valuable?

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

What needs improvement?

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. 

For how long have I used the solution?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Virtualization Manager at NMC Health
Real User
Very good for analysis but visualization is somewhat lacking
Pros and Cons
  • "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."
  • "Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user friendly and easier to use. Tableau is very easy to use. It's just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau."

What is our primary use case?

We use Tableau for visualization and SAS EG for analysis. SAS EG is more useful for analysis, while Tableau is better for visualization.

What is 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.

What needs improvement?

Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user-friendly and easier to use. Tableau is very easy to use. It just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau.

Tableau just adds a few visualization aspects onto it, but it doesn't have powerful analytics like SAS. You can join a number of tables in SAS. That's what I find very useful. You can keep on doing that. You can just change one and get another report. You can save the script and run it again. SAS has all kinds of useful features, so I think it is very good for analysis.

We actually saved millions of dirhams on licensing data, just by sitting here and getting data for a month. Now they're developing their routine using it as if it's Excel. I need to develop it because they don't really have it here. They were only using Tableau, but Tableau basically just sums up the analysis. It cannot do certain analyses. Mostly it's summing up and finding the fraction and percentage. You can easily do that, but it is a bit tricky to use because you cannot join so many tables and you cannot double it. That kind of function is not there in Tableau. That is the main drawback in Tableau.

SAS is very good actually. It's not really user-friendly and it's difficult to configure as well. It's difficult to configure the graphs and charts. In Tableau, it's really easy to do that and I think that can easily be developed in SAS, considering that there are complex analysis functions already provided by the solution.

It should also be easy to integrate any database like PostgreSQL. I have spent more than one hour on more than one occasion trying to connect it, but it did not work. I think that should not be the case. It should be just really comfortable to do this.

For how long have I used the solution?

I worked at the Daman insurance company for four years and they used SAS EG all the time. Now I am at another company that uses both SAS EG and Tableau. 

What do I think about the stability of the solution?

The stability is quite good. However, I found out that we don't have a direct connection to the database. The company I'm working at now doesn't have a data warehouse. Data needs to be exported into Excel and then re-imported into SAS EG. That is going to be a little tricky because we really want all the rules to be imported. That's an issue. I don't know how deep the problem is, but there's a software limitation in importing so many Excel files and then joining them to the database. In Daman, where I worked earlier, we had direct connectivity to the database, besides the fact that we had a data warehouse.

What do I think about the scalability of the solution?

Right now, I don't know. I feel that before we build anything, we need to validate the data. Validating the data can be very tough and tedious. For instance, the other day I took one year and six months of data from a hospital and I'm now importing it one month at a time. It's very tedious. They needed data for their whole warehouse.

Then it would be very useful to have a lot of people working on it. It could take off nicely. First, you need to know that the data is correct, though. Right now, we don't know that the data is correct. It is very important to clean the data and ensure that your work is providing data which is really what you're trying to measure. That itself takes some time.

I import data each month and check that the number matches. I check that the net amount is correct. It all takes time. I know it's true if somebody else gets the same answer. Importing is where the issue is, though. That is where I'm having trouble because sometimes I find there's only partial importation.

I insert an extended table in the columns and rows with good formatting so that it doesn't miss anything. I think that that works well.

How are customer service and technical support?

I have contacted them. We are currently having a problem because I have two databases. One is a pharmacy and I am trying to connect to the pharmacy database. They're allowing me to connect to their line. However, SAS EG is not connecting to the database on the pharmacy side. There are two sides, the pharmacy-side, and the hospital-side. On the pharmacy side, their data is available on the screen, but it's not connecting.

We've tried them both several times. They came online and tried on their end also. Everybody tried to find history, but they were just getting stuck. They went through so many stages. Importation was very successful, but trying to get the last days did not succeed. There was some issue there. They saw this issue in every pharmacy database that was directly connected to Tableau. They usually manage their data with Tableau and so I had to export it from there.

How was the initial setup?

The initial setup was simple. Once you understand the concept of their scale, how they join, and the logic behind the whole thing. If you know how to join tables this shouldn't be difficult. It's not complex. The tables are complex, but the underlying principles are not complex.

We had a three-day introductory course only. It doesn't tell you every unique case. There are a lot of things, but you can figure it out. I think you start doing it right away, but then you can go to YouTube and see someone use it as well.

I've got a first degree in mathematics, so I understand this kind of concept easily. That is my background. Still, I need to know how this works. We figured it out from YouTube and friends. Now I understand the product well.

When I joined this company, they did not have SAS at that time. They did not know what SAS was. They only had Tableau. I told them to let me try that with that. I taught myself Tableau and could use it because I knew that the concepts are the same. The logic is the same. Boolean algebra is the same. Just like that, I started using it. Within two hours, I started using Tableau.

Now I have SAS also, so I am using both now.

What other advice do I have?

I would rate it quite high, but because I don't have experience with other similar solutions, I cannot say how good this is. I have nothing to compare it to, as my experience is limited to SAS EG and Tableau. For my purposes, it has been great, but I don't know how well it can find patterns by itself with machine learning.

I read in the newspapers and the internet that so much more is doable. The preliminary analysis could be done with a machine. Right now we have average, mean, median, but machine learning could provide much more.

From that, instead of looking at thousands of lines, one could just look at a few graphs and see where you should dig further into. Perhaps you could have a video or dashboard.

I don't mean generic dashboards. I mean a dashboard, which you can then pull up and down to see what else is there. They have that technology these days. I think it should be possible without stretching too much.

I would rate this solution as seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Sr Manager - Reporting, Analytics and Quality Control (Business Transformation) at Golden 1 Credit Union
Real User
An easy-to-use interface for working with large datasets

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.
Portfolio Analytics Manager at heritage
Real User
I find the click and drop function to be valuable

What is our primary use case?

  • Data preparation
  • Statistics.

How has it helped my organization?

Efficiency.

What is most valuable?

Click and drop function.

What needs improvement?

Licensing.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Business Intelligence Analyst at a financial services firm with 501-1,000 employees
Real User
Scheduling downtime of some programs has been eliminated
Pros and Cons
  • "Scheduling downtime of some programs has been eliminated."
  • "We do not bother any longer with some programs did not run, hence having to rerun them again."
  • "We now mostly use the Enterprise Guide for such scheduling purposes, so error processes will not inhibit the others."
  • "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."

What is our primary use case?

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.

How has it helped my organization?

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

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

Less than one year.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Estela Lutero - PeerSpot reviewer
Economist at a government with 1,001-5,000 employees
Real User
It has improved our communication with senior management

What is our primary use case?

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

How has it helped my organization?

It has definitely improved our communication with senior management.

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

More than five years.

Which solution did I use previously and why did I switch?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Risk and Fraud Analyst at a financial services firm
Real User
An excellent tool for data manipulation and analysis
Pros and Cons
  • "An excellent tool for data manipulation and analysis."
  • "SAS EG offers many excellent features, such as parallel execution on the same server, controlling output datasets in the process flow, and conditional processing."
  • "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."
  • "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."

What is our primary use case?

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

How has it helped my organization?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

More than five years.

Which solution did I use previously and why did I switch?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Mathieu Gaouette - PeerSpot reviewer
Consultant BI senior - spécialité SAS at a financial services firm
Consultant
Brought better performance by having people work on a powerful server instead of a workstation
Pros and Cons
  • "Brought better performance by having people work on a powerful server instead of a workstation."
  • "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."

What is our primary use case?

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

How has it helped my organization?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

More than five years.

Which solution did I use previously and why did I switch?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Vice President, Enterprise Data Management, Analytics CoE at a financial services firm with 10,001+ employees
Real User
Its user interface and code builder are valuable features of the product

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.
it_user824289 - PeerSpot reviewer
Statistician
User
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.
it_user254223 - PeerSpot reviewer
Project Manager - Business Intelligence at www.datademy.es
Consultant
Great Tool for Data Management and Analytics Tasks.

What is most valuable?

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.

How has it helped my organization?

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

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

An eight out of 10.

Which solution did I use previously and why did I switch?

I have also used R. Both are good tools.

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

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

Which other solutions did I evaluate?

I have also used R. Both are good tools.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.