Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

SAS E Miner PMML to Sql

Reply
New Contributor
Posts: 2

SAS E Miner PMML to Sql

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

Super User
Posts: 17,840

Re: SAS E Miner PMML to Sql

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

 

 

New Contributor
Posts: 2

Re: SAS E Miner PMML to Sql

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.

Super User
Posts: 17,840

Re: SAS E Miner PMML to Sql

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.

 

SAS Super FREQ
Posts: 272

Re: SAS E Miner PMML to Sql

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.

Ask a Question
Discussion stats
  • 4 replies
  • 472 views
  • 0 likes
  • 3 in conversation