cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
JensRiege
Level IV

Multiple Contingency Tables - How do I get the name of the filter category

I am creating a report based on a very large set of Contingency tables created by using Fit Y by X,  by factor Z.  Example:

A Data Table has three columns X, Y, Z

When I select Analyze, Fit Y by X, By factor Z,  I get all contigency tables, where each table is for each Z factor.  

The only row in each contingency table I want is the row% so I deselected display of the other three rows before selecting Make into a Data Table after right clicking on the red arrow.

After turning off Mosic Plots and Tests, and leaving just the Contingency tables, I want to concatenate all of these tables into a single table with a column that lists the Z factor for each table. Since each Z factor does not appear to be stored with each Contingency Table, how to I capture this Z factor data to be assocated with each contingency table?

4 REPLIES 4
JensRiege
Level IV

Re: Multiple Contingency Tables - How do I get the name of the filter category

This is some of the code I have so far, assuming that there are multiple contingency tables open:

Names Default To Here( 1 );
Clear Log();
// Create a list of all table names:
dtList = {};
For( i = 1, i <= N Table(), i++,
	dt = Data Table( i );
	Insert Into( dtList, dt );
);
Eval( dtList[1] ) << New Column( "added column", set each value( 5 ) );
Show( dtList );

// Trying to create a single table from all of the Open Contingency Tables
For( i = N Table(), i >= 0, i--,
	Concatenate( dtList[i], "Append to first table", "Create source column" )
);
ron_horne
Super User (Alumni)

Re: Multiple Contingency Tables - How do I get the name of the filter category

Hi @JensRiege 

i would attempt using other platforms to produce the final table you are looking for.

the first thing that comes in mind is Analyze >> Tabulate.

image.png

second option: Table >> summary

image.png

i find these much more versatile and controllable.

please let us know if this helps at all.

ron

 

JensRiege
Level IV

Re: Multiple Contingency Tables - How do I get the name of the filter category

Thank you Ron for your suggestion.

I am reviewing the documentation on the Tabulate Platform to see if I can get the same results that the Contingency Analysis provides in the Analyze Fit Y by X platform.

ron_horne
Super User (Alumni)

Re: Multiple Contingency Tables - How do I get the name of the filter category

Hi @JensRiege ,

Try to see the two scripts in the attached data table.

if you need any help from there let us know.

ron