topic Re: Model Studio 'Append' equivalent in SAS Data Science

Model Studio 'Append' equivalent

tom_evans_79 — Fri, 18 Dec 2020 14:21:29 GMT

Hi,

In Enterprise Miner there was an 'Append' node that joined together two tables or subtables. Is there an equivalent in Model Studio?

In some situations, it is better to build two independent models to be applied to different parts of a population. To find the best way to split the sample, we want to build models with various splits and compare the discriminatory power of the combined results. Model Studio is great for comparing different models, but to do this we need to be able to split and then recombine different parts of the sample. I think I can do the splitting part in Model Studio, but can't find a way to re-attach the two parts such that each part of the split is scored by the correct model. Any ideas?

Here's the Enterprise Miner flow that we want to replicate in Model Studio:

Many thanks,

Tom.

Re: Model Studio 'Append' equivalent

gcjfernandez — Sat, 06 Mar 2021 18:07:58 GMT

Please use the SAS code node to append the two scored data files.

Re: Model Studio 'Append' equivalent

tom_evans_79 — Mon, 08 Mar 2021 07:05:25 GMT

Thanks for the reply, @gcjfernandez .

I can only connect 1 predecessor node to a SAS code node, but for the node to work as a generic 'append' it would need at least 2 predecessors.

I could probably work out how to merge the two tables using SAS code, but if the code would need changing every time then it isn't worth using DMML.

Tom.