SAS Enterprise Guide
We use SAS Enterprise Guide for reporting purposes. It is easy to use with Excel (importing, exporting) so it's easy to share the final …
SAS Enterprise Guide
SAS Enterprise Guide
Overview
Recent Reviews
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SAS Enterprise Guide, and make your voice heard!
Pricing
View all pricingN/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?
14 people want pricing too
Alternatives Pricing
N/A
Unavailable
What is Dataiku DSS?
Dataiku is a French startup and its product, DSS, is a challenger to market incumbents and features some visual tools to assist in building workflows.
What is IBM SPSS?
SPSS Statistics is a software package used for statistical analysis. It is now officially named "IBM SPSS Statistics". Companion products in the same family are used for survey authoring and deployment (IBM SPSS Data Collection), data mining (IBM SPSS Modeler), text analytics, and collaboration and…
Features Scorecard
No scorecards have been submitted for this product yet.Start a Scorecard.
Product 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
View all alternatives
Reviews and Ratings
 (26)
Reviews
(1-11 of 11)- Popular Filters
Companies can't remove reviews or game the system. Here's why
March 20, 2022
SAS Enterprise Guide
We use SAS Enterprise Guide for reporting purposes. It is easy to use with Excel (importing, exporting) so it's easy to share the final output with businesses. It can also be used for large-scale projects that can be written in SAS Enterprise Guide and then transfer the whole project to business people for future use. It has an easy-to-understand design, so even a person with little technical knowledge can use it.
- communicate with Excel
- schedule many little tasks
- automating tasks
- errors could be more detailed
- when you export in different excel sheets, its grouped together, which could be a problem in certain circumstances
- it would be nice to have a function to tell if some tables is open and by whom
July 23, 2021
No one does it better
SAS Enterprise Guide has been playing a significant role in analytics and statistical programming in my organization. It has helped to solve enormous business needs and proffer solutions to various organizational problems. It is mostly used by departments and teams that are responsible for conducting data analysis and empirical research. It provides accurate results and drives an evidence-based decision-making process.
- Accurate results
- Helps to drive factual decision-making process
- Easy to learn and use
- Very compatible with existing and new IT architecture
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
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
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.
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.
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.
April 01, 2019
SAS EG
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
February 23, 2019
SAS EG : A wholesome tool to extend analytics capabilities, but cost could be a concern
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.
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.
August 09, 2018
SAS/Enterprise Guide, the Analyst's swiss knife
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.
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.