Date:         Wed, 6 Sep 2006 18:58:44 -0600
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      Re: SASuser versus SAS programmer
Comments: To: Joe Whitehurst <joewhitehurst@gmail.com>
In-Reply-To:  <129a50e0609061710xfebf0edk7cec64a58de2d340@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Free roaming SAS users brought their warehouse to its knees by unmanaged
queries. This allows users to go into a creative mode after the
heavy-lifting happens. Plus the user's defined the UI and what they needed.

Many EG users are tossed into understanding joins, indices, etc. to make the
initial queries efficient. They are not programmers but are asked to
understand the impact of a multi-table join between tables that are 100M
row+. IT is helping them out tremendously by getting step 1 out of the way
and working with them on what they need. That isn't Neanderthal to me: it's
smart business.

Alan

Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net



-----Original Message-----
From: Joe Whitehurst [mailto:joewhitehurst@gmail.com]
Sent: Wednesday, September 06, 2006 6:11 PM
To: Alan Churchill
Cc: SAS-L@listserv.uga.edu
Subject: Re: SASuser versus SAS programmer

Alan,

Having Neanderthal IT managers manage and control anything not only will
stifle all creativity, no useful work will ever be accomplished.
The real gains will come by forcing Neanderthal IT management to look at all
the creative possibilities generated by free roaming SAS Users.

Joe.

>This forces not> only better analysis but also a process that IT can
control and manage.
>
> Previously, 10 different users would get 10 different results for the
> same question and their queries would drag down the DW performance.