TrustRadius
One of the best and easy to use tool for data analysis and data manipulation.It is used in my current project in which I use SAS9.4 and the business problem is related to the churning of customers from retail stores. For that, I use this tool to draw some inferences. Inbuilt procedures give it a lot of power by which work becomes very easy. It is used in all of the departments and as per the client requirements.,It can load a huge amount of data as compared to R Studio and Excel. Data processing speed is very fast, millions of records are loaded into this software very easily and data manipulation is also very easy. Inbuilt Statistical functions and procedures make it very comfortable to use for non analytics professionals as well.,It is a costly software to use as compared to R studio and Python which are free for users. No addition to the packages that are currently required for Image processing etc. It is just a tool that is used for data cleaning or data manipulation or to draw statistical output. I think a number of tools are doing the same. No new changes that I have seen to it from the last 3-4 years. Data visualization charts are not that good using the tool.,8,SAS EG has improved the overall efficiency as data processing is very fast and the results are highly accurate. It's one license cost is much more than the salary of some of the employees here and it takes a few months to recover that cost. Overall profit has increased as people learn it very fast and start deploying the work very easily.,RStudio and IBM SPSS,RStudio, Microsoft SQL Server, Tableau DesktopSAS EG : A wholesome tool to extend analytics capabilities, but cost could be a concernSAS EG is being used in the Credit Risk Analytics domain within Wholesale Banking for validating models along with build analytics queries for quick refresh & slide-dice data for the regulatory requirements. Also, we often create project files (.egp) to record the flow of codes. Import/export data and the underlying connections among pieces is also stored in one place. It is frequently used for carrying out statistical analysis like ANOVA, univariate, and regressions for model development.,EG v7. 1 offers a GUI approach to query building as opposed to predecessors like Base SAS v9.1. It's easy for non-programming background users. EG offers better connectivity with a remote server, while in an earlier version we had to segregate script using "rsubmit' blocks Project files is a great feature (with process flow) in EG which was missing in earlier versions. It's a preferred choice for people with SQL backgrounds, as proc SQL is a quite similar and easy to use procedure.,Proc Import & Export usage via code is still a problem, rather one needs to do it manually at times (using the wizard). Visualization capabilities and cost could be an improvement that the next versions should bring. Cost is also a concern compared to other products.,8,Cost vs Technical Support ratio is high. Analytical capabilities have improved department-wise (with credit risk).,Tableau Desktop,Tableau Desktop, QlikView,1000,58,For Credit risk review of Obligors. For New credit product originations & account management. For Collection & recovery strategies. For Predictive Modelling.,Integration with Hadoop cluster to enhance connection with multitudes of data sources while maintaining high performance.,Setting up Group Stress testing teams onshore who do Monte Carlo simulations and share their set of scenarios to Group Economics teams. It is a data & analytics oriented work and requires SAS along with visualizations with statistics capabilities.,8,No,Product Features Product Usability Prior Experience with the Product,The choice would be SAS Enterprise Guide only until a better product (rather, suite) replaces it in performance & cost both.,Don't know,7,Yes,7,No,Adhoc query (using query builder) Simple Interface, Slicing & dicing of data using In-built filters Text mining & predective modelling Web interface of Advance analytics,Query builders are very slow with large data (can be learnt from other tools available in market) Need to use Proc Printo to automatically redirect logs to disk, could be automated.,Yes, but I don't use it,9SAS EGFor now, Business Intelligence Analysts use it for writing SAS codes and more recently, we're able to schedule, run, and keep a version history of processes from a SharePoint site. That is so cool as it was a solution we had been looking for to keep a version history of our foremost operational processes. SAS EG is so easy to deal with and manipulate.,Easy slicing and dicing of data Keeping version history,Process flow,10,Enabled better decision making Provided forecasts that give room to anticipate.,IBM SPSSSAS Enterprise Guide is SAS' best attempt at being user-friendly. Does well at it.SAS Enterprise Guide is used across the organization for creating a more user-friendly SAS experience. SAS Enterprise is mostly used by analysts that prefer a point-and-click interface as opposed to base SAS programming. The software is used for querying databases, forecasting, and data visualization. It is used every day for advanced analytics in support of others that only know spreadsheet-type work.,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.,SAS Enterprise Guide is nowhere near as efficient as base SAS. The program takes longer to load up, and running analytics on multiple millions of records takes much longer than base SAS. The default coloring schemes of SAS Enterprise Guide are hideous. If you plan on presenting the results of SAS Enterprise Guide graphics, be prepared to make a number of coloring changes. The base SAS code produced by SAS Enterprise Guide is good, although it still requires some clean-up. And sometimes the created code doesn't work when attempting to re-run it on the same analysis. That doesn't happen too often, but sometimes.,10,SAS Enterprise Guide saves tons and tons of time. An analyst that makes $100/hr programming base SAS should be able to get a job done in a third of the time, meaning a savings per day of around $500. If you use SAS or plan to use SAS, I think SAS Enterprise Guide is the best add-on. Because SAS makes many analytical processes easy to perform, sometimes less experienced analysts will pretend to know what they are doing simply by trusting what SAS is doing. Essentially, the software may lure some analysts into a false sense of professional knowledge. If you're someone who criticizes model building for a living, you'll likely need to spend time with such individuals, explaining where they went wrong and what SAS is doing. Although SAS Enterprise Guide is not as fast as base SAS (because of all the additional features), it is still much quicker than any free tool I have tried. The proficiency makes up for the cost of the software.,MATLAB, Microsoft BI, SAP HANA, SAP HANA Express Edition, Microsoft Access, Amazon SageMaker, IBM SPSS Modeler, IBM SPSS, RStudio, Anaconda, JMP Statistical Discovery Software from SAS, JMP Pro, RapidMiner Studio, Alteryx Analytics, MicroStrategy Analytics and KNIME Analytics Platform,MATLAB, Alteryx Analytics, KNIME Analytics Platform, QGIS, Anaconda, RStudio, IBM SPSS Modeler, RapidMiner Studio, Amazon SageMaker, Apache Spark, Microsoft BI, SAP HANASAS/Enterprise Guide, the Analyst's swiss knifeSAS Enterprise Guide is used in several business units including marketing, HR, risk (all units). At a high level, it is used for data preparation for analytics developments (models, segmentation, forecasting, ...) and also for ad-hoc queries and data exploration. Being a 4th level programing language, a lot of business users like it. It is somewhat easy and quick to learn. SAS/Enterprise guide brings that ease at the next level with lots of built-in tasks that can be used instead of code. So in terms of business problems, let's say that SAS/Enterprise Guide is a tool to answer business questions whichever they are.,Get detailed information about a datasource quickly with built in statistical tasks. Join data from different of different nature from multiple sources (provided you have the associated SAS/Access component). Structure projects with a visual interface and allow dependencies between them. Easy to structure and maintain.,I would like to see advance interactions with external databases to be able to kill ongoing queries from SAS. As of now, you can stop pretty much any ongoing process besides the one running on a remote database (killing SAS/EG doesn't stop the remote process) When creating prompts for programs, it would be nice to be able to have conditional prompts (based on the selection of other prompts). The prompts are clearly a recent feature and constantly under development but I wish it would be more powerful. More of a SAS metadata issue but when loading SAS/EG (first connection to the server), it takes a few seconds which feels like a long time. I really don't understand why the initialization of the session can take so long. Don't get me wrong, this has no real impact on productivity but that 10s delay just feels really like eternity when you want to run some code in a new session.,9,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.,IBM SPSS,SAS Enterprise Miner
  3. SAS Enterprise Guide Reviews
Unspecified
SAS Enterprise Guide
7 Ratings
Score 8.1 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SAS Enterprise Guide Reviews

SAS Enterprise Guide
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Do you work for this company? Manage this listing

Show Filters 
Hide Filters 
Filter 7 vetted SAS Enterprise Guide reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Show All Filters
More Filters 
Less Filters 

Reviews (1-5 of 5)

Do you use this product? Write a Review
Akshaya Bhardwaj profile photo
April 03, 2019

One of the best and easy to use tool for data analysis and data manipulation.

Akshaya Bhardwaj
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is used in my current project in which I use SAS9.4 and the business problem is related to the churning of customers from retail stores. For that, I use this tool to draw some inferences. Inbuilt procedures give it a lot of power by which work becomes very easy. It is used in all of the departments and as per the client requirements.
  • It can load a huge amount of data as compared to R Studio and Excel.
  • Data processing speed is very fast, millions of records are loaded into this software very easily and data manipulation is also very easy.
  • Inbuilt Statistical functions and procedures make it very comfortable to use for non analytics professionals as well.
  • It is a costly software to use as compared to R studio and Python which are free for users.
  • No addition to the packages that are currently required for Image processing etc.
  • It is just a tool that is used for data cleaning or data manipulation or to draw statistical output. I think a number of tools are doing the same. No new changes that I have seen to it from the last 3-4 years.
  • Data visualization charts are not that good using the tool.
SAS EG is well suited in the case of normal reporting and when drawing some inferences. For this, the software is very good. Its coding is also very simple which makes it easier to learn for beginners. The ODS(Output Delivery System) by which we can put the output into PDF/XML formats is also a very unique feature. Scenarios where it is less appropriate include: When we need to perform EDA(Exploratory Data Analysis) through charts and graphs, then this tool fails because of poor visualizing capability.


Read Akshaya Bhardwaj's full review
Rohit Narang profile photo
February 23, 2019

SAS EG : A wholesome tool to extend analytics capabilities, but cost could be a concern

Rohit Narang
Score 8 out of 10
Vetted Review
Verified User
Review Source
SAS EG is being used in the Credit Risk Analytics domain within Wholesale Banking for validating models along with build analytics queries for quick refresh & slide-dice data for the regulatory requirements. Also, we often create project files (.egp) to record the flow of codes. Import/export data and the underlying connections among pieces is also stored in one place. It is frequently used for carrying out statistical analysis like ANOVA, univariate, and regressions for model development.
  • EG v7. 1 offers a GUI approach to query building as opposed to predecessors like Base SAS v9.1. It's easy for non-programming background users.
  • EG offers better connectivity with a remote server, while in an earlier version we had to segregate script using "rsubmit' blocks
  • Project files is a great feature (with process flow) in EG which was missing in earlier versions.
  • It's a preferred choice for people with SQL backgrounds, as proc SQL is a quite similar and easy to use procedure.
  • Proc Import & Export usage via code is still a problem, rather one needs to do it manually at times (using the wizard).
  • Visualization capabilities and cost could be an improvement that the next versions should bring.
  • Cost is also a concern compared to other products.
Well Suited to:
1. Carry out ad-hoc analysis and use basic statistical reports.
2. Query Builder for users with GUI likelihood to design queries.
3. For writing complex macros once for repetitive tasks & repeating with multiple iterations of different parameters, it is very useful.
Not Suited for:
1. Using pass through to read large datasets could be very resource & time-consuming.
Read Rohit Narang's full review
No photo available
April 01, 2019

SAS EG

Verified User
Score 10 out of 10
Vetted Review
Verified User
Review Source
For now, Business Intelligence Analysts use it for writing SAS codes and more recently, we're able to schedule, run, and keep a version history of processes from a SharePoint site. That is so cool as it was a solution we had been looking for to keep a version history of our foremost operational processes. SAS EG is so easy to deal with and manipulate.
  • Easy slicing and dicing of data
  • Keeping version history
  • Process flow
When you need to keep a version history of your codes, Enterprise Guide is a good go-to. You can easily revert to previous versions though it creates a newer version as well.
Read this authenticated review
Thomas Young profile photo
January 25, 2019

SAS Enterprise Guide is SAS' best attempt at being user-friendly. Does well at it.

Thomas Young
Score 10 out of 10
Vetted Review
Verified User
Review Source
SAS Enterprise Guide is used across the organization for creating a more user-friendly SAS experience. SAS Enterprise is mostly used by analysts that prefer a point-and-click interface as opposed to base SAS programming. The software is used for querying databases, forecasting, and data visualization. It is used every day for advanced analytics in support of others that only know spreadsheet-type work.
  • 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.
  • SAS Enterprise Guide is nowhere near as efficient as base SAS. The program takes longer to load up, and running analytics on multiple millions of records takes much longer than base SAS.
  • The default coloring schemes of SAS Enterprise Guide are hideous. If you plan on presenting the results of SAS Enterprise Guide graphics, be prepared to make a number of coloring changes.
  • The base SAS code produced by SAS Enterprise Guide is good, although it still requires some clean-up. And sometimes the created code doesn't work when attempting to re-run it on the same analysis. That doesn't happen too often, but sometimes.
I think SAS Enterprise does a great job for SAS analysts that don't have a very good grasp of base SAS. The software makes SAS much more user-friendly. With that said, SAS Enterprise Guide also does a very good job offering a host of per-packaged graphics and data transformations. I can't image using base SAS without SAS Enterprise anymore. I think SAS Enterprise Guide is most useful for traditional analytical processes, such as time-series forecasting, outlier detection, and econometrics. I think the software is less useful for advanced machine learning or AI. SAS' Enterprise Miner does a much better job at that.
Read Thomas Young's full review
Mathieu Gaouette profile photo
August 09, 2018

SAS/Enterprise Guide, the Analyst's swiss knife

Mathieu Gaouette
Score 9 out of 10
Vetted Review
Verified User
Review Source
SAS Enterprise Guide is used in several business units including marketing, HR, risk (all units). At a high level, it is used for data preparation for analytics developments (models, segmentation, forecasting, ...) and also for ad-hoc queries and data exploration. Being a 4th level programing language, a lot of business users like it. It is somewhat easy and quick to learn. SAS/Enterprise guide brings that ease at the next level with lots of built-in tasks that can be used instead of code.
So in terms of business problems, let's say that SAS/Enterprise Guide is a tool to answer business questions whichever they are.
  • Get detailed information about a datasource quickly with built in statistical tasks.
  • Join data from different of different nature from multiple sources (provided you have the associated SAS/Access component).
  • Structure projects with a visual interface and allow dependencies between them. Easy to structure and maintain.
  • I would like to see advance interactions with external databases to be able to kill ongoing queries from SAS. As of now, you can stop pretty much any ongoing process besides the one running on a remote database (killing SAS/EG doesn't stop the remote process)
  • When creating prompts for programs, it would be nice to be able to have conditional prompts (based on the selection of other prompts). The prompts are clearly a recent feature and constantly under development but I wish it would be more powerful.
  • More of a SAS metadata issue but when loading SAS/EG (first connection to the server), it takes a few seconds which feels like a long time. I really don't understand why the initialization of the session can take so long. Don't get me wrong, this has no real impact on productivity but that 10s delay just feels really like eternity when you want to run some code in a new session.
SAS/Enterprise Guide is a great tool to give to an analyst in a company. I call it the swiss knife of analytics. It allows lots of functionalities from the integration of data and transformation to predictive modeling (if you have the Stat module).
I recommend it for ad-hoc data querying and manipulations.
For ETL processes, I suggest going with a proper ETL software that has data tracability.
As for reporting, it will work just fine but don't expect the same levels of customizations and "wow" as reporting softwares such as Tableau.
Read Mathieu Gaouette's full review

SAS Enterprise Guide Scorecard Summary

Likelihood to Recommend (7)
8.1
Likelihood to Renew (1)
8.0
Usability (1)
9.0
Support (1)
7.0
Implementation (1)
7.0

About SAS Enterprise Guide

SAS Enterprise Guide is a menu-driven, Windows GUI tool for SAS.
Categories:  Predictive Analytics

SAS Enterprise Guide Technical Details

Operating Systems: Unspecified
Mobile Application:No