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

How to intergrate SAS and IBM DataStage

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

How to intergrate SAS and IBM DataStage

[ Edited ]

How can i work on the output of the SAS Miner and load the outPut into another Application like IBM DataStage to make an ETL process in DataStage 


Accepted Solutions
Solution
‎05-30-2016 02:14 PM
Super User
Posts: 19,868

Re: How to intergrate SAS and IBM DataStage

It depends. 

If you're just talking about moving data around, that's different.  

 

 

If you want to implement the model in another environment SAS provides scoring code in several flavours. 

There's definitely a SAS data step code, C, Java and PMML, but not native SQL one. 

 

I'm fairly certain IBM supports PMML in some way. 

http://www.itweb.co.za/index.php?option=com_content&view=article&id=14815

 

Otherwise you can convert your datastep code to SQL manually. It won't be fun, but is likely doable. 

 

 

 

 

View solution in original post


All Replies
Solution
‎05-30-2016 02:14 PM
Super User
Posts: 19,868

Re: How to intergrate SAS and IBM DataStage

It depends. 

If you're just talking about moving data around, that's different.  

 

 

If you want to implement the model in another environment SAS provides scoring code in several flavours. 

There's definitely a SAS data step code, C, Java and PMML, but not native SQL one. 

 

I'm fairly certain IBM supports PMML in some way. 

http://www.itweb.co.za/index.php?option=com_content&view=article&id=14815

 

Otherwise you can convert your datastep code to SQL manually. It won't be fun, but is likely doable. 

 

 

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 493 views
  • 0 likes
  • 2 in conversation