TrustRadius Insights
SAS Enterprise Guide is a versatile software that is widely used across various departments within organizations. Users appreciate its …
Overview
What is SAS Enterprise Guide?
SAS Enterprise Guide is a menu-driven, Windows GUI tool for SAS.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
N/A
Unavailable
What is SAS Enterprise Guide?
SAS Enterprise Guide is a menu-driven, Windows GUI tool for SAS.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
93 people also want pricing
Alternatives Pricing
What is SAP Analytics Cloud?
The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…
What is RapidMiner?
RapidMiner is a data science and data mining platform, from Altair since the late 2022 acquisition. RapidMiner offers full automation for non-coding domain experts, an integrated JupyterLab environment for seasoned data scientists, and a visual drag-and-drop designer. RapidMiner’s project-based…
Product Details
- About
- Tech Details
What is SAS Enterprise Guide?
SAS Enterprise Guide is a menu-driven, Windows GUI tool for SAS.
SAS Enterprise Guide Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(28)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
- Recommendations
SAS Enterprise Guide is a versatile software that is widely used across various departments within organizations. Users appreciate its ease of use and quick learning curve, making it accessible to both beginners and experienced analysts. With this software, users can conduct data statistics and data quality verification, query databases, forecast future trends, and visualize data in a meaningful way. It empowers users to perform advanced analytics tasks, particularly those who are more familiar with spreadsheet-type work.
The application of SAS Enterprise Guide extends beyond basic analytics and is commonly utilized in different domains such as Credit Risk Analytics within Wholesale Banking. Here, it helps with model validation and analytics queries. Furthermore, users rely on the software for statistical analysis such as ANOVA, univariate, and regressions for model development. Across multiple business units like marketing, HR, and risk, SAS Enterprise Guide aids in data preparation, ad-hoc queries, and data exploration.
One notable feature highly valued by users is the ability to schedule, run, and keep a version history of processes from a SharePoint site. This functionality ensures the reproducibility of analyses and offers a convenient way to track progress over time. Additionally, SAS Enterprise Guide excels at data cleaning, manipulation, and analysis activities. It handles large datasets effortlessly while allowing users to export cleaned data for further examination or visualization.
Overall, SAS Enterprise Guide is praised for its versatility in solving complex analytical problems across departments such as finance, marketing, operations, and risk management. Whether it's generating reports, performing deep analysis on large datasets or shaping data for specific needs - SAS Enterprise Guide proves to be an indispensable tool for businesses aiming to leverage their data effectively.
Flexible in working with different data sources: Users have praised SAS Enterprise Guide for its flexibility in working with various data sources, making it highly adaptable for different teams. Some reviewers specifically mentioned that this feature allows them to easily integrate and analyze data from multiple databases or file formats.
Easy generation of SQL code: Reviewers who may not be proficient in SQL appreciate the ability of SAS Enterprise Guide to generate SQL code easily. This feature simplifies the process of querying databases and extracting relevant information, enabling users to perform data analysis tasks without extensive programming knowledge.
Point-and-click interface for easy data manipulation: The point-and-click interface of SAS Enterprise Guide is highly appreciated by users as it allows them to create graphics, transform data, and perform statistics without the need for extensive programming knowledge. Several reviewers mentioned that this feature enables them to quickly access and manipulate data, saving time and effort in their analyses.
Difficult User Interface: Several users have expressed frustration with the user interface of SAS Enterprise Guide, finding it difficult to navigate and slow to develop. They have mentioned that there is excessive clicking required, which slows down their workflow.
Lack of Data Viewing Capability: Some users have highlighted the software's lack of ability to view data on the fly as a major drawback. This limitation makes it challenging for them to assess the impact of changes they make, hindering their decision-making process.
High Licensing Costs: Many reviewers believe that SAS Enterprise Guide is not worth its high price tag. They feel that the software does not provide enough value compared to free alternatives like Pandas, R Studio, and Python.
Reviewers highly recommend SAS EG as an effective ETL tool for handling large datasets. They appreciate its efficient data extraction, transformation, and loading capabilities, making it suitable for data analysis tasks. Additionally, users commonly praise SAS EG for its ability to meet regulator compliance requirements, thanks to its robust features and functionalities in this area. With these recommendations, it's evident that SAS EG is a reliable choice for working with large datasets and ensuring regulatory compliance.
Attribute Ratings
Reviews
(1-5 of 5)Companies can't remove reviews or game the system. Here's why
We use it for analytics, and rough end extracts. This gives our staff administrative permissions to handle inside their SAS workflows, adding external data, and retaining repeatable steps to generate the same extract. We have both PC and Server SAS. My team uses the server a lot to handle larger analytical jobs. It is also used to handle data statistics and verify data quality.
- Flexible to data sources
- Works well across teams
- Helps with SQL code writing
- Difficult to write quickly, particularly if you need to change something in the data flow
- Lots of clicking, slow to develop
- Doesn't view data on the fly, hard to see what impact a particular change might have
- Lots of licensing costs, very costly for what it does, basically equivalent to Pandas, but with huge cost tag
- Integrates IT development with analytical/business areas by giving a "code share"
- Visual of data flow helps communicate process to others
- Reasonably shares programs with team mates
Python-based platforms like Pandas or Spark are very good too at displaying data and do exploratory analysis. I definitely prefer them to SAS EG. It's just too slow, and doesn't let you peek into the data very easily. Lots of clicking, and I'd rather just write some code, rather do clicking.
April 22, 2020
Powerful tool for analysis
SAS Enterprise Guide is used by analysts in our unit to generate reports and clean data. It is used to perform analysis on large datasets and to combine data from multiple sources.
- Map out process used to clean data and generate reports
- Integrate with base SAS
- GUI format is easy to use
- Price
- Getting started using this software can be intimidating
- It has been an essential part of our reporting capability.
- Able to save time on recreation of reports or making necessary modifications.
- Procurement process from our state has been challenging.
This was used by the unit before I joined. It was compared to SPSS but I was not included in that discussion.
December 18, 2019
SAS EG Review
We use SAS EG in the Business Intelligence and Research Departments for creating ad hoc and ongoing data shaping for reports. Mostly these are output to CSV files to be ingested into Qlik or Excel for further visualization and exploration. Some of the features EG has like the GUI for filtering, sorting and summarizing the data are useful for investigating the data attributes but most of the time I use short queries in SAS sql to get the insight I'm after. The Explore option in the dataset list in the servers can be handy because it allows you the freedom to use drop downs in the variable names for filters as is the cases in Excel or SAS studio however it's very slow if you're going to do this on a large dataset.
- Ability to load an AutoExec when opening a session ensuring everyone has the same global variables.
- Formatting with Ctrl I. If you're reading someone else's code and it's not formatted correctly you can highlight the area and hit Ctrl I.
- SAS Studio has some great examples that can be implemented. Adding a filter to the output datasets for one.
- Some issues around having to enter my password every time I open it up. Some people are having this issue and others aren't. SAS admin is at a loss to work out why it's occurring.
- I'm not involved in the financial side of SAS implementation, however the use of data to gain insight into the daily running of the business is always a must have and SAS EG has played an integral part in keeping the Executives up to date with work flow and financial information.
Although not used in the enterprise, I have used Anaconda Python to shape and cleanse data from Excel reports that was too difficult for SAS to complete. The object oriented nature and the Pandas package made ingestion of the data and reshaping more useful in this use case. Anaconda was only on my local machine in this case so it wasn't an enterprise option. In this case, the IDE I was using was Spyder. It's window compartment for variable and data frame creation is very helpful as the information is only a click away and the compartment also had metadata around the variable/data frame showing it's size and shape.
October 09, 2019
Good tool for data cleaning, analysis and manipulation
I used SAS Enterprise Guide for data cleaning, data manipulation and data analysis activities. The data gathered from different databases are introduced to the program, furthermore data mapping, data cleaning and analysis rules are coded through the Graphical User Interfaces of SAS EG. Then we get the export of the cleaned data for further analysis such as filtering, searching or grouping.
SAS EG is a powerful tool for data cleaning and analysis activities. We have used SAS EG for finance department. But it can also be used for customer data analysis in marketing or operations departments.
- Data cleaning, reformatting, manipulation and analysis.
- User friendly GUI for introducing SAS Queries.
- Easy to send the project tree to different users.
- Easy to import data from external files such as txt, Excel. Can handle big data sets.
- Project tree structure is easy to understand as you need SAS EG to make many calculation activities.
- Process time of data is a bit long. It depends on the size of your data and complexity of your project tree.
- There is not enough online free training videos.
- While working with the project tree sometimes the links between the modules are broken or the order for running the modules get mixed up. You should know your project tree by heart.
- Faster decision making, through powerful big data handling functionalities.
- Faster operations on daily basis, once the project tree is built, unskilled personnel can use it in their daily operation.
- Don’t need to choose SAS EG if you are not going to be handling big data. (such as over 1 million rows and 50 columns)
- You need skilled personnel to build the initial project tree.
SAS EG has better Graphical User Interface to build project trees and help users to create data queries/calculations. SAS EG can handle bigger data sets compared to other programs. You can easily clean the data sets and manipulate the data. It is easier to send the project tree to other users. However SAS EG has less free online training material over internet.
February 23, 2019
SAS EG : A wholesome tool to extend analytics capabilities, but cost could be a concern
Score 8 out of 10
Vetted Review
Verified User
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.
- Cost vs Technical Support ratio is high.
- Analytical capabilities have improved department-wise (with credit risk).
Tableau : A good tool for visualisations but SAS is better for running production scripts & using adhoc analysis
1000
Credit risk model development, portfolio analytics, group reporting teams
58
Advance Sas certified programmers
System support
Advance Data warehousing
Remote server setup
System support
Advance Data warehousing
Remote server setup
- 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.
No
- Product Features
- Product Usability
- Prior Experience with the Product
Organisation wide acceptability and strong positive feedback.
The choice would be SAS Enterprise Guide only until a better product (rather, suite) replaces it in performance & cost both.
- Don't know
Yes
As mentioned, it is the choice of features it offers along with the acceptability
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