topic SAS E Miner PMML to Sql in SAS Data Science

SAS E Miner PMML to Sql

farooqmunir66 — Fri, 29 Jan 2016 11:11:02 GMT

How can we convert SAS E-miner PMML to SQL (for teradata)?

Re: SAS E Miner PMML to Sql

Reeza — Fri, 29 Jan 2016 12:54:36 GMT

What kind of model is it? Logistic regression, neural networks, decision tree, ensemble model?

I googled and found this tool, which appears to be free...

http://www.pmml2sql.com/info.asp#learnmore

Re: SAS E Miner PMML to Sql

farooqmunir66 — Fri, 29 Jan 2016 13:07:26 GMT

Thanks Reeza. I have different models including regression, Decision tree and neural network and have to convert these to SQL. Yes I already have visited the link you mentioned and also some other links on google but these all are for some other softwares, I have find no tool to convert SAS PMML to SQL.

Re: SAS E Miner PMML to Sql

Reeza — Sat, 30 Jan 2016 19:53:04 GMT

I might be mistaken, but I thought PMML was a standard and as such they should be interchangeable within a current version at least. So any tool that does the migration should work.

I also think SAS EM has different scoring extracts, so you can look at the other options - SAS code, PMML, C, or Java and see if they meet your need.

Re: SAS E Miner PMML to Sql

WendyCzika — Mon, 01 Feb 2016 14:24:58 GMT

Yes as Reeza mentions, I don't think PMML score code is the way to get there. See the Reference Help on the Score Code Export node. This can take the DATA step score code that is produced for a flow and create the files needed to deploy in a database.