822663_en-US

liliconcom

JMP > Multiple Response Modeling > Retrieve List of Individual Responses

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

 

 

 

Content OrganizationWindowsRe: JMP > Multiple Response Modeling > Retrieve List of Individual Responses

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

Re: JMP > Multiple Response Modeling > Retrieve List of Individual Responses

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