JMP > Multiple Response Modeling > Retrieve List of Individual Responses

[#1]

Hi JMP Community,

JMP 17.2 on Windows 10

I have a Table listing Pathways and their constituents (Overlap_gene) with a Multiple Response modeling type from a publication. 

How can I assemble a list of all unique entries in the Overlap_gene from this table?

Of note, the Data Filter tool provides the breakdown of unique entries as desired, but I have not figured out how to retrieve them as a list.

Thank you,

Best,

TS

[#2 · Accepted solution]

One option is to use Distribution and extract the values from the Frequencies table by making a data table

Names Default To Here(1);
dt = Current Data Table();
dist = dt << Distribution(Multiple Response Distribution(Column(:overlap_genes)));
dt_vals = Report(dist)["Frequencies", Table Box(1)] << Make Into Data Table;
vals = dt_vals[0,1];
close(dt_vals, no save);
dist << Close Window;

show(vals);

[#3]

ver< elegant!

Another option: split the entries into multiple columns, stack them and the calculate a summary:

dt = current data table();
n1 = ncols(dt);
dt << Text to Columns( columns( :overlap_genes ), Delimiters( ",", " " ) );
n2 = ncols(dt);

dtstack = dt << Stack(
	columns(Eval(n1+1 ::  n2)),
	Drop All Other Columns( 1 ),
);

dtstack << Select Where( :Data == "" ) << Delete Rows;

dtstack << Summary(	Group( :Data ));