SAS Enterprise Guide vs Microsoft SQL Server

• 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.

Read full review

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Read full review

• 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

Read full review

• The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
• Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
• The documentation is not great and again it's generally better to obtain help elsewhere if needed

Read full review

• 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.

Read full review

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Read full review