Date:         Fri, 30 Sep 2005 10:14:18 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Converting SAS code to SQL
Content-Type: text/plain; charset="us-ascii"

Joe:
The whole idea of a 'scorecard' is to hide a complex statistical model
so a busy executive does not have to deal with its complexities. I don't
imagine that it would be easy to extract a simple, parametric model from
a scorecard, and I really can't imagine that SAS would set up an export
function that would generate a predictive model object that would run
under MS SQL Server. Wishful thinking, I'd say.

If you are developing a parametric model in SAS PROC GENMOD, SAS ODS
makes it easy to extract parameter estimates. A short while ago I posted
a program that will do that. Sig

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Joe
Sent: Friday, September 30, 2005 5:09 AM
To: sas-l@uga.edu
Subject: Re: Converting SAS code to SQL


I am also looking at doing something similar to this.  Once a scorecard
has been created in SAS, is there any easy way to convert this into an
SQL procedure to append the score data to the SQL database that can be
run independently of SAS?

TIA

Joe