Date: Fri, 30 Sep 2005 14:27:10 -0700
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: Converting SAS code to SQL
Content-Type: text/plain; format=flowed
>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?
If you can transcribe the code for generating the scorecard values, then
you can do it.
If you are using a neural net or something, then you have already obfuscated
the process enough that you may not be able to do more than feed the
neural net inputs and catch the outputs. You won't be able to write that
in SQL. Ever.
If you have used statistical tools and built straightforward models, then
may have usable formulae for scorecarding, and you can transfer that
knowledge to another language. If, however, you realize that you might
need things like standard errors to go with those point estimates, then you
are back to 'stuck', since many models use esoteric computations to derive
appropriate error estimates.
So. What's the point of paying for a tool like SAS EM, and then not wanting
utilize the rest of the SAS package afterward? You *do* know that you can't
assume your scorecard will work well forever, and you'll need to do this as
iterative process, right?
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Donít just search. Find. Check out the new MSN Search!