JMP Multiple Response Modeling Retrieve List of Individual Responses

Question

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

ORANGE_RA PAIN TOP PATHWAYS with OVERLAP GENES.jmp

jthi · Accepted Answer

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);