Output developed model to SQL code?

[_Jimmy]

Hi everyone.

I searched the forum first but couldn’t find an answer because I am sure this question has been asked somewhere. Is there a way to output the model you developed in Knime into SQL code so you can implement it another program such as SAS?

Thanks everyone.

[izaychik63]

Look at

PMML to SQL — NodePit

Not sure it will work in SAS.

[mlauber71]

You can transform several models into PMML and then into SQL. Decision trees can also be transformed into rules that you can then convert into some if then else … rules

For SAS you could try to use PROC SQL and the output code.

Looking for options to evaluate a decision tree

Hi, I am currently looking into options to make use of KNIME for a rather small use case. We have a decision tree we want to evaluate but the use case (business case) is too small and isolated to buy and setup KNIME server. My idea was to train the tree, write a PMML file and then use a library within a REST service to make evaluations. To my surprise there do not seem to be too many options at hand: so far I discovered SMILE which does not seem to read PMML files and JPMML(-Evaluator) . Has a…

We discussed which models use PMML here:

Export PMML that outputs class probabilities

I think it depends on the type of model. Normally you would have to tell the Predictor to add the class probabilities. The generic PMML predictor does not have this function - or it depends on the type of model. [image] Nodes that support Probabilities and PMML are: Additionally the Decision Tree offers the possibility to create a quite readably ruleset that you can then use with SQL or another language Additionally the Supports these model types and also has the possibility to…

I think it could be possible to use PMML in SAS (but you would have to check if it works, PROC PSCORE); keep in mind that you will have to include all the data transformations also. From my experience PMML is compatible in theory but once you start implementing real models you have to put in some effort.