Reviews (1-7 of 7)
- 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.
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.
- 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.
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.
- Easy to access sas datasets and relational databases
- Can write custom sas codes for validation
- Statistics and analytics functions are present
- Performance tuning when connected to and querying data from servers
- Add visualization functionality for easy reporting
- More connection drivers to other external databases like sales force and cloud
- 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.
- 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.
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.
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.
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.
SAS Enterprise Guide Scorecard Summary
About SAS Enterprise Guide
SAS Enterprise Guide Technical Details