What is our primary use case?
SQL can be used with SAS. We also use Microsoft SQLs, which I still use on occasion. Part of the background is that the coding can be done using SQL. SAS allows you to write SCL statements and is mostly drag and drop, similar to Microsoft Access.
That is the SAS Enterprise Guide's drag-and-drop functionality.
What is most valuable?
I like the ease of use.
Similar to Microsoft Access, you can drag and drop. You can simply drag and drop objects onto the page and create various flows to establish your query within the project. You can extract those queries from the preview as needed.
The application uses standard SQL in the background. You can go behind the scenes and use the information you want to change.
I like the interface where you can get help if you need it. They also have functions that can be called up to perform various tasks. For example, If you want to write a case statement for something, just put that function in there and see what syntax you might be missing.
What needs improvement?
It crashes more frequently than I would like. For example, you can create projects, but with our data system, the field changes from time to time. Our data-driven managers will occasionally attempt to update. They speed up everything and change the names of the fields slightly. When you go back in there and try to make changes, the project frequently crashes. When you attempt to make those various changes. And it can take some time to get it right. I guess what I'm working on right now is a project that I completed two years ago and needed to be re-run. It's also crashing because the data fields have changed.
It just gets stuck in a never-ending loop. Then you must control, alt, delete, and return to the program's main menu to exit. That's a little frustrating.
I would like it to give more information rather than just a forever loop that forces you to shut down the system. Give you more error messages without stopping the entire project, or even the entire application. That it displays more error messages rather than terminating the application.
For how long have I used the solution?
I have been working with SAS Enterprise Guide for 10 years.
We keep it updated, and are using the most recent version.
We are currently transferring some of its data to the cloud, including some of the storage files.
What do I think about the scalability of the solution?
It is used by our entire office as well as my old office. I work for the Department of Education and previously worked for another part of the state, and they both use it. SAS is used by others in the state. It's a well-known program.
How are customer service and support?
I have not contacted technical support recently, regarding this most recent issue.
Which solution did I use previously and why did I switch?
I'm familiar with KNIME, but it's been a while since I've used it. I took a look at it in the last 12 months, and I like how they combine flows for different purposes.
We had previously used SPSS in a BI query, but we switched to SAS about ten years ago.
They have SAS E Miner. I don't have much experience with it; I used it two years ago, but it includes a statistical practice package.
What's my experience with pricing, setup cost, and licensing?
I did look at the prices a few years ago, and I believe it was approximately $1,000 for a yearly subscription at that time. I knew it was something I wouldn't be able to afford if I wanted to do some consulting. That was one of the reasons I looked into KNIME. There are several alternatives to SAS.
What other advice do I have?
I would rate SAS Enterprise Guide an eight out of ten. They are good, but they could be better.
Which deployment model are you using for this solution?
On-premises