topic Re: Split &outtable from process node in SAS Customer Intelligence

Split &outtable from process node

GoExplore — Tue, 26 Jul 2016 21:08:05 GMT

Is there a way to split "&outtable" from Process node into multiple nodes? Similar to Split node.

similar to the screenshot below

Re: Split &outtable from process node

pcapazzi — Tue, 26 Jul 2016 22:23:44 GMT

Yes, but you can only do it using a Stored Process (option "Process" selected) that you create. But you cannot create multiple outputs with embedded code in the node (option "Code" selected) unfortunately.

Re: Split &outtable from process node

SteveMarshall — Wed, 27 Jul 2016 15:43:57 GMT

From the MA User Guide:

"The default number of output cells that is generated is set by the NumberofCells keyword in the stored process. The MinCells and MaxCells keywords specify the minimum and maximum number of cells. The NumberofCells keyword does not have to be specified. If the MaxCells value is specified, and MinCells and NumberofCells values are not specified, the minimum number of rows is 1. If only the MinCells value is specified, the maximum number of rows is unlimited. "

several macro variables provided to your Stored Process are useful for understanding the input and output MATables:

OUTTABLE0 and INTABLE0 have the number of OutTable and Intable MATablenames available via OUTTABLEN (where n=1-&OUTTABLE0)

Re: Split &outtable from process node

Gwen777 — Fri, 09 Feb 2018 21:22:29 GMT

Hi Steve,
Does that mean, that I have to assign the name of my generated table to outtable1 etc.? And if yes, can I still work with work (eg outtable1= ‘work.table1‘)?
Maybe you can give a really short example of a stored process which generates multiple cells in ci?

Thank you in advance!
Anja

Re: Split &outtable from process node

SteveMarshall — Wed, 14 Feb 2018 15:09:38 GMT

Anja,

the &outtable1-n macro variables are populated with fully qualified table names (like MATABLES.Tabcdefstmars) by MA and passed into the stored process. You need to create/populate each of these &outtable s with appropriate subjectIDs (based on your code). You need to create every outtable (number of outtables is in &outtable0) even the outtable has 0 subject_IDs that qualify. I will try to add a sample process in the next week.

Re: Split &outtable from process node

ChrisLemberg — Tue, 28 Apr 2020 12:56:11 GMT

although this post is really old.

But what is the solution?

I'm having a similar problem. I am not able to figure that one out

Greetings

Christopher