Solved: How to intergrate SAS and IBM DataStage

saleh · Posted 05-03-2016 10:22 AM

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

Reeza · Posted 05-03-2016 11:43 AM

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.

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

Reeza · Posted 05-03-2016 11:43 AM

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.

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

How to intergrate SAS and IBM DataStage