Great thread.
The place where I consult only uses SAS Enterprise Guide 4.1 on the desk top and has 9.1.3 on the server side. SAS is used to get data from a variety of sources, Oracle DB, SQL Server, MS/Access, and a plethora of legacy flat files.
I mostly use SAS to create the SAS datamarts from those data sources. We use SAS EG for heavy data processing work and use the Code window for the vast majority of the processes.
Also, it is very convient for the non-programmer to have a link to the SAS Datamart, Oracle DB, and SQL Db and join away in a single application, versus toggling through TOAD, etc.
So with the same tool, I (the developer) uses SAS EG mostly for ETL work. While the operations research staff uses it to run analysis (statistical analysis, reporting, etc.). One cool feature is the use of macro parameters. With a simple drop down the analysts can run a variety of scenarios without coding a single peice of code.
As I mentioned before using the same interface as the end-users makes my life as a developer a bit easier.
Darryl
... View more