Is there a way to split "&outtable" from Process node into multiple nodes? Similar to Split node.
similar to the screenshot below
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.
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)
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.
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
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.
Find more tutorials on the SAS Users YouTube channel.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)