Date:         Thu, 20 May 2004 14:25:20 -0600
Reply-To:     Michael Murff <murffmj@LDSCHURCH.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Murff <murffmj@LDSCHURCH.ORG>
Subject:      Re: SAS and Interactive Spreadsheets (Advanced Excel)
Comments: To: pardee.r@ghc.org
Content-Type: text/plain; charset=us-ascii

The data is actually stored natively in Oracle tables. SAS is what I am most
comfortable, but I am not necessarily opposed to other solutions.

Mike

>>> "Pardee, Roy" <pardee.r@ghc.org> 5/20/2004 1:49:04 PM >>>
How married are you to SAS for this?

Personally, I'd be tempted to ODBC the sas data into a database & then
have excel VBA move the data back and forth between excel & the db.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Michael Murff
Sent: Thursday, May 20, 2004 12:29 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS and Interactive Spreadsheets (Advanced Excel)


Hi SAS-L,

Here's a description of a product we are considering developing.

A human resource department wants to give supervisors the ability to
allocate raises rather than have central HR use a deterministic function
(based on review rating, quartile position, and grade). The idea is to
deliver a spreadsheet to supervisors' desktops that contains "rules";
the worksheet would have a list of divisional employees and a "pot",
where the pot is the total amount of money the supervisor is allowed to
spend for his group. The supervisor would be allowed to give a
percentage raise within a set of bounded intervals. Inputting a
percentage increase for one employee would "debit" the divisional pot
thus constraining the allowable increases given to the rest of the
group.

While this would be a simple matter of writing a few formulas / or some
VBA code in Excel, how can SAS be enabled to write formulas that would
be written into an outputted spreadsheet containing information from a
SAS dataset (using ODS / DDE / OLE)? In short, can formulas be embedded
into a spreadsheet version of a SAS dataset.

The completed spreadsheet would then be sent back to HR (a SAS server)
and loaded and aggregated into a table for further analysis and
implementation.

Advice on what SAS products and techniques might work would be much
appreciated.

Mike Murff
SLC, Utah

"Postmaster" made the following annotations.
------------------------------------------------------------------------
------
This message may contain confidential information, and is intended only
for the use of the individual(s) to whom it is addressed.
 =======================================================================
======



"Postmaster" made the following annotations.
------------------------------------------------------------------------------
This message may contain confidential information, and is intended only for
the use of the individual(s) to whom it is addressed.
 =============================================================================