Good tool for data cleaning, analysis and manipulation
October 09, 2019
Good tool for data cleaning, analysis and manipulation
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.
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