I am currently using this solution for testing purposes. I am working for a pharmaceutical company in Belgium, and we are building a data warehouse by using SAS Data Integration Studio, and we are using SAS Enterprise Guide to test our development. We are building Enterprise Guide projects by using query builder, filters, and other things. We have also built stored procedures. Sometimes, we also write SAS base code to perform unit tests after development and to do some sanity checks to respond to UAT questions. Overall, we are using the majority of functionalities of SAS Enterprise Guide.
Mostly accessing medical claims data from mainframe warehouses, plus occasional spreadsheets, etc. Aggregating and scoring according to specified algorithms and identifying medical practitioners who are statistical outliers with respect to certain procedures. Loading results of these analyses into Microsoft SQL Server and writing queries for access by users without SAS licenses. Running SAS EG on a networked Windows PC, connected to a SAS Grid on a Unix network, accessing data warehouses in Teradata.
Our primary use case is to analyze the sales data of our company. We have an in-house database that has all data relating to our agents and our production. I use it when I want to have a quick check on the data. I'm the finance system and process senior manager in the company.
We use this solution for moving users that need statistical data analysis and data transformation functionality that do NOT have a background in programming and/or SQL to a tool that allows for some degree of self-service. It also provides access to data sources (databases that require administrative access) that do not support individual user access.