1. Home
  2. Predictive Analytics Software
  3. SAS Enterprise Guide Reviews
  4. User Review of SAS Enterprise Guide
Good tool for data cleaning, analysis and manipulation
October 09, 2019

Good tool for data cleaning, analysis and manipulation

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SAS Enterprise Guide

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.
I did not use the technical support of SAS EG. I can say that I have had hard time to find online tutorials or projects for SAS EG. For instance, it is hard to find completed researches or designed algorithms used with SAS EG. Sometimes it just depends on user's skill set and experience with databases and programming.

Do you think SAS Enterprise Guide delivers good value for the price?

Yes

Are you happy with SAS Enterprise Guide's feature set?

Yes

Did SAS Enterprise Guide live up to sales and marketing promises?

Yes

Did implementation of SAS Enterprise Guide go as expected?

I wasn't involved with the implementation phase

Would you buy SAS Enterprise Guide again?

Yes

Good Scenario: The user is confident with SQL, Algorithm designing or at least have some programming experience before starting SAS EG. Then he can easily import data from databases or external sources and complete actions such as cleaning or analysis. You can group the billing data and consumption of your customers. Clean the data through easy filters then group the customers into segments and start your analysis.

Bad Scenario: When you want to show this analysis in fancy Dashboards. Well it is better to export the final data set and then use a better dashboard tool.